-- sqlServer 设置唯一键
use DB_LZ17
ALTER TABLE prdt_samp
ADD
CONSTRAINT noRepeat UNIQUE (prd_code)
-- sqlServer zai prdt_samp li cha zhao prd_code chong fu xiang
--设置约束不重复不太好,容易让其他约束设置不上去
select * from prdt_samp where prd_code in
(select prd_code from prdt_samp group by prd_code having count(prd_code ) > 1)
order by prd_code desc
---可以不直接设置约束而是
-- 设置非空
ALTER TABLE prdt_samp ALTER COLUMN prd_code varchar(255) NOT NULL;
-- 设置唯一
ALTER TABLE prdt_samp ADD UNIQUE (prd_code);
----删除约束
ALTER TABLE prdt_samp DROP CONSTRAINT noRepeat
-- 设置非null
alter table prdt_samp alter column prd_code varchar(255) not null