Re: Using SQL to find PKs for each table

From: Newbie (noidea_at_nospam.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 15:28:35 -0000

SELECT COLS.CONSTRAINT_NAME,COLS.COLUMN_NAME,CONS.TABLE_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS COLS
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS CONS ON COLS.CONSTRAINT_NAME
= CONS.CONSTRAINT_NAME
WHERE CONS.CONSTRAINT_TYPE = 'PRIMARY KEY'

HTH
"alan" <anonymous@discussions.microsoft.com> wrote in message
news:393a01c3e295$e16e42d0$a501280a@phx.gbl...
> What is the SQL query to find the Primary Keys for each
> user table in a database?
>
> Regards,
> Alan

Relevant Pages