mssql constraint

-- 准备
CREATE TABLE TA (ID INT,TA_NAME VARCHAR(30));
CREATE TABLE TB (ID DECIMAL(10,0),TB_NAME VARCHAR(30));

-- 主键
ALTER TABLE DBO.TB ADD CONSTRAINT PK_TA PRIMARY KEY (ID) 
-- 修改列定义添加外键
ALTER TABLE TB ALTER COLUMN ID INTEGER;
--DELETE FROM TB;
--ALTER TABLE TB DROP CONSTRAINT FK_TB_TA;
BEGIN TRANSACTION
ALTER TABLE TB WITH NOCHECK ADD CONSTRAINT 
  FK_TB_TA FOREIGN KEY(ID) REFERENCES TA (ID)
GO
COMMIT
GO

-- 添加约束
-- ALTER TABLE TB DROP CONSTRAINT TB_VALUE_CK;
-- 唯一约束
ALTER TABLE TB ADD CONSTRAINT CK_U_TB_VALUE UNIQUE(VALUE);
-- 添加其他约束
ALTER TABLE TB WITH NOCHECK ADD CONSTRAINT TB_VALUE_CK CHECK (VALUE IN ('A','C') );

-- 查询
EXEC SYS.SP_HELPCONSTRAINT @OBJNAME = N'TB'