ALTER TABLE on ADD, ALTER, DROP column_name

常用的表格欄位新增異動語法 MS SQL

--加欄位ADD column
ALTER TABLE my_table_name ADD my_column_name nvarchar(50)

--異動資料類型ALTER COLUMN
ALTER TABLE my_table_name ALTER COLUMN my_column_name nvarchar(50)

--移除欄位DROP COLUMN
ALTER TABLE my_table_name DROP COLUMN my_column_name

Copyright © Bruce Huang All rights reserved.