sqlserve DDL

DDL：Data Definition Language数据定义语言

1、添加列

alter table Sp_FinanceInfo add PayAccountJson bit;

追加注释

EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = '付款账户Json', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Sp_FinanceInfo', @level2type = N'COLUMN', @level2name = N'PayAccountJson';

2、修改列

alter table PC_PaidInStatisticLog alter column Remark nvarchar(512)

3、删除列

alter table Sp_FinanceInfo drop column PayAccountID;

4、修改列名

EXECUTE sp_rename N'dbo.PC_ActualPaidStatisticLog.PaidInDetailID', N'ActualPaidDetailID', 'COLUMN'

5、添加主键

ALTER TABLE dbo.PA_ActualPaid ADD CONSTRAINT
PK_PA_ActualPaid PRIMARY KEY CLUSTERED (ID)

6、添加索引

CREATE nonclustered index IX_PA_ActualPaidLog_ActualPaidID
on PA_ActualPaidLog(ActualPaidID)
with(drop_existing=off)