BUG: Unable to Drop a Constraint with a Period in the NameID: Q189804
|
If you create a constraint with periods in the constraint name, you cannot
drop the constraint after it is created.
When you try to drop the constraint that has periods in its name using a
statement similar to:
alter table mytable drop constraint "constraint.name"
Msg 3731, Level 16, State 0
'constraint.name' is not a valid object.
Msg 3727, Level 16, State 0
Unable to drop constraint. See Previous Error
To work around this problem, do not create constraints with periods in their names.
Microsoft has confirmed this to be a problem in SQL Server version 6.5 We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Using SET QUOTED_IDENTIFIER ON, you are able to create constraints with
periods in their names. After these constraints are created, you are unable
to drop them.
Additional query words: constraint,quoted_identifier
Keywords : SSrvGen kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug
Last Reviewed: April 21, 1999