How to alter column size in SQL?

Question

Can anyone tell me how to alter column size in SQL?

Answer 1

Suppose you want to define the column with datatype varchar and size of 10. Here is the SQL query if you want to alter the column size to varchar (20):

ALTER TABLE table_name

ALTER COLUMN col_1 varchar (20);

If you wish to learn SQL from Industry experts then take up this SQL training and certification program by Intellipaat that provides instructor-led training, and also certification.