ALTER TABLE Style_FileInfo ADD nDataType INT NOT NULL CONSTRAINT DataType_DEFAULT DEFAULT(0) WITH VALUES
ALTER TABLE Style_FileInfo DROP CONSTRAINT DataType_DEFAULT
ALTER TABLE Style_FileInfo DROP COLUMN nDataType
–查找约束
sp_help Style_FileInfo
ALTER TABLE Style_FileInfo ADD nDataType INT NOT NULL CONSTRAINT DataType_DEFAULT DEFAULT(0) WITH VALUES
ALTER TABLE Style_FileInfo DROP CONSTRAINT DataType_DEFAULT
ALTER TABLE Style_FileInfo DROP COLUMN nDataType
–查找约束
sp_help Style_FileInfo