SQL Server 添加或修改列
－－添加列
IF NOT EXISTS(SELECT * FROM SYSCOLUMNS WHERE id=OBJECT_ID(‘tbl_TranWOAndCoCHistoryByRAILASSURE‘) AND name=‘CreatedDate‘)
BEGIN
ALTER TABLE tbl_TranWOAndCoCHistoryByRAILASSURE
ADD CreatedDate DATETIME NOT NULL DEFAULT GETDATE()
END
－－修改列
IF EXISTS(SELECT * FROM SYSCOLUMNS WHERE id=OBJECT_ID(‘tbl_TranWOAndCoCHistoryByRAILASSURE‘) AND name=‘CreatedDate‘)
BEGIN
ALTER TABLE tbl_TranWOAndCoCHistoryByRAILASSURE
ALTER COLUMN CreatedDate NVARCHAR(10)
END
－－1.删除列，先删除默认值约束名
IF EXISTS(SELECT * FROM SYSCOLUMNS WHERE id=OBJECT_ID(‘tbl_TranWOAndCoCHistoryByRAILASSURE‘) AND name=‘CreatedDate‘)
BEGIN
ALTER TABLE tbl_TranWOAndCoCHistoryByRAILASSURE
DROP constraint DF__tbl_TranW__CreatedDate__359DCDD0
END
－－2.删除列
IF EXISTS(SELECT * FROM SYSCOLUMNS WHERE id=OBJECT_ID(‘tbl_TranWOAndCoCHistoryByRAILASSURE‘) AND name=‘CreatedDate‘)
BEGIN
ALTER TABLE tbl_TranWOAndCoCHistoryByRAILASSURE
DROP COLUMN CreatedDate
END
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
