Modify a data type of a column which contains data in it

Q.  Can we modify a data type of a column which contains data in it?
- Published on 16 Jun 15

a. Yes
b. No

ANSWER: No
 
Whenever a column has a data in it and we try to modify the data type of the column we cannot modify it if it has some data in it. Once the data is removed we can modify the column.

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲