Donny Mack : QUICK TIP: Determining Primary Key field of a table.

posted on Wednesday, February 02, 2005 11:35 AM by DonnyMack

QUICK TIP: Determining Primary Key field of a table.

USE NORTHWIND
SELECT COLUMN_NAME FROM Information_schema.KEY_COLUMN_USAGE WHERE Table_Name='Categories'

Anyone have a more efficient way? I know there is somewhere!

Post a Comment ::

Comments

# re: QUICK TIP: Determining Primary Key field of a table.

Saturday, November 26, 2005 8:43 PM by Marchaos

That wilk not give you the primary keys of a table as it will also include the unique keys.