How to rename/change column datatype in SQL
How to rename/change column datatype in SQL
sql rename column
alter table command is quite used in many situations. We need this to edit our schema. If we create any table and if we want to change the datatype of any column in our table, we can use the alter command.
The syntax is
alter table table-name alter column column-name datatype constrain.
The constrain may be NULL or NOT NULL or UNIQUE etc...