ALTER TABLE TABLE_NAME ADD COL_NAME NVARCHAR(50) NULL
GO
数据库修改字段(非空):
UPDATE TABLE_NAME SET COL_NAME=''
GO
ALTER TABLE TABLE_NAME ALTER COLUMN COL_NAME NVARCHAR(50) NOT NULL
GO
给数据库中字段改名:
sp_rename 'TABLE_NAME.COL_NAME','NEW_NAME','COLUMN'
ALTER TABLE TABLE_NAME ADD COL_NAME NVARCHAR(50) NULL
GO
数据库修改字段(非空):
UPDATE TABLE_NAME SET COL_NAME=''
GO
ALTER TABLE TABLE_NAME ALTER COLUMN COL_NAME NVARCHAR(50) NOT NULL
GO
给数据库中字段改名:
sp_rename 'TABLE_NAME.COL_NAME','NEW_NAME','COLUMN'
转载于:https://www.cnblogs.com/lcwzj/archive/2009/03/16/1412879.html