Quote:
Originally Posted by jyaseena
How can I change the name of the column ? and in big sized database design if I change the name of the column How can we solve this cumbersome task..?
|
First:
Alter table <tablename>
drop column <columnname>
Second:
Alter table <tablename>
add(<columnname> <datatype>)