On Transact SQL language the Msg 15252 Level 16 - The primary or foreign key table name must be given.
Msg 15252 Level 16 Example:
Invalid command:
USE tempdb;
GO
EXEC sp_fkeys
@pktable_owner = 'dbo';
GO
| Message |
|---|
| Msg 15252, Level 16, State 1, Procedure sp_fkeys, Line 22 |
| The primary or foreign key table name must be given. |
Correct command:
USE tempdb;
GO
EXEC sp_fkeys
@pktable_name = 'DEPARTMENTS',
@pktable_owner = 'dbo';
GO
Other error messages:
- Cannot drop the table
- Is not a constraint
- Create View or Function failed because no column name was specified
- Cannot define PRIMARY KEY constraint on nullable column in table
- String or binary data would be truncated
- The database name component of the object qualifier must be the name of the current database
- No item by the name of '%' could be found in the current database.
