SQL
追逐路上的小人物
没有
展开
-
Sybase(IQ) 查询表结构,添加主键,和删除主键
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:字段.原创 2021-03-31 11:12:52 · 2424 阅读 · 2 评论 -
Sybase (ASE库)删除主键,添加复合主键
1.Alter table inv_invoicedetail Drop constraint pk_inv_invoicedetailinv_invoicedetail:表名pk_inv_invoicedetail:主键名 ,可通过sp_help 表名查询2.添加主键alter table inv_invoicedetail add constraint pk_inv_invoicedetail primary key clustered (s_number,standard...原创 2021-03-31 11:00:45 · 595 阅读 · 2 评论