Home  >  Article  >  Database  >  SQL Server禁止/解禁全部约束应用到数据表

SQL Server禁止/解禁全部约束应用到数据表

WBOY
WBOYOriginal
2016-06-07 14:55:071311browse

SQL Server禁止/解禁全部约束应用到数据表 SQL Server ALTER TABLE tb1NOCHECK CONSTRAINT ALLGO ALTER TABLE tb1CHECK CONSTRAINT ALLGO

SQL Server禁止/解禁全部约束应用到数据表 SQL Server
ALTER TABLE tb1
NOCHECK CONSTRAINT ALL
GO
ALTER TABLE tb1
CHECK CONSTRAINT ALL
GO
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn