我正在使用sql Server 2008.我需要找到默认值约束是否不存在然后创建它.这是我尝试过的.
@H_502_4@
- IF (NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_NAME ='MyConstraint'))
- BEGIN
- ALTER TABLE [XX] ADD CONSTRAINT [MyConstraint] DEFAULT ((-1)) FOR [XXXX]
- END
- GO
解决方法
@H_502_4@ @H_502_4@
- if not exists (
- select *
- from sys.all_columns c
- join sys.tables t on t.object_id = c.object_id
- join sys.schemas s on s.schema_id = t.schema_id
- join sys.default_constraints d on c.default_object_id = d.object_id
- where t.name = 'table'
- and c.name = 'column'
- and s.name = 'schema')
- ....