BUG: ALTER TABLE NOCHECK CONSTRAINT Excluded When Scripting Database (272319)
The information in this article applies to:
This article was previously published under Q272319
BUG #: 58318 (SQLBUG_70)
SYMPTOMS
Use the SQL Server Query Analyzer and perform the following:
- Create a table.
- Alter the table to add a constraint.
- Alter the table again and put a NOCHECK constraint on the same table.
When scripting the table by using the SQL Server 7.0 Enterprise Manager, the NOCHECK syntax is excluded.
WORKAROUND
If you have a copy of the SQL Server 2000 SQL Enterprise Manager available, use that version instead to script the table.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug kbDSupport KB272319 |
|---|
|