--为表增加主键
ALTER TABLE dbo.s_User2Subject ADD CONSTRAINT pk_s PRIMARY KEY(User2SubGUID)
--表的列设置非空属性
ALTER TABLE dbo.s_User2Subject ALTER COLUMN User2SubGUID UNIQUEIDENTIFIER NOT NULL
--增加一列
ALTER TABLE dbo.myUser ADD appStatus VARCHAR(10)
--删除一列
ALTER TABLE dbo.s_User2Subject DROP COLUMN appStatus
--myUser表的AppStatus,列名更新为ApprovedStatus
exec sp_rename 'myUser.AppStatus','ApprovedStatus','column';