CB_Beginner的博客

1.查看表结构sp_iqhelp 表名 2.添加主键约束 alter table inv_invoicedetail add constraint pk_inv_invoicedetail primary key clustered (s_number,standard,productcode,rownumber)inv_invoicedetail ：表名pk_inv_invoicedetail ：主键keys_number,standard,productcode,rownumber:字段 .

1.Alter table inv_invoicedetail Drop constraint pk_inv_invoicedetail inv_invoicedetail：表名 pk_inv_invoicedetail：主键名 ，可通过sp_help 表名查询 2.添加主键 alter table inv_invoicedetail add constraint pk_inv_invoicedetail primary key clustered (s_number,standard...