Suggest table names or contsraint names for DBCC CHECKCONSTRAINTS
SQL Prompt should properly suggest table names or constraint names for DBCC CHECKCONSTRAINTS.
The correct syntax would be:
DBCC CHECKCONSTRAINTS('SchemaName.TableOrConstraintName')
Currently, it suggests this way:
DBCC CHECKCONSTRAINTS(TableName)
which only works if TableName is in the dbo schema.
1
vote
Razvan Socol
shared this idea