Altering column size in SQL Server

Altering column size in SQL Server
ALTER TABLE table_name
ALTER COLUMN column_name datatype;
LIKE::
ALTER TABLE `product` MODIFY COLUMN `updatedon` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Leave a Reply

Your email address will not be published. Required fields are marked *