Check if a Primary Key Exists on a Table
November 10, 2017
You can use IF NOT EXISTS?to check whether a Primary Key is missing and add it as follows: IF NOT EXISTS (SELECT * FROM sys.tables tINNER JOIN sys.schemas s ON
Menu
You can use IF NOT EXISTS?to check whether a Primary Key is missing and add it as follows: IF NOT EXISTS (SELECT * FROM sys.tables tINNER JOIN sys.schemas s ON