I have a primary key constraint set up in a table - "tCustomerSessions" with the name "PK_tCustomerSessions".
Below is my query -
SELECT *
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_NAME = 'tCustomerSessions'
AND Constraint_Type = 'PRIMARY KEY'
Here how do i get the name of the column on which the primary key constraint has been set up ?
Aucun commentaire:
Enregistrer un commentaire