How do you list the primary key of a SQL Server table?

by 
SELECT Col.Column_Name from 
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab, 
    INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col 
WHERE 
    Col.Constraint_Name = Tab.Constraint_Name
    AND Col.Table_Name = Tab.Table_Name
    AND Constraint_Type="PRIMARY KEY"
    AND Col.Table_Name="<your table name>"

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Get top 1 row of each group
  3. How to return only the Date from a SQL Server DateTime datatype
  4. How to calculate age (in years) based on Date of Birth and getDate()
  5. Convert Month Number to Month Name Function in SQL
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Limit on the WHERE col IN (…) condition
  8. Generate Dates between date ranges
  9. Select group of rows that match all items in a list
  10. Add Foreign Key relationship between two Databases
  11. How to print VARCHAR(MAX) using Print Statement?
  12. How to assign an exec result to a sql variable?
  13. Query error with ambiguous column name in SQL
  14. Why (and how) to split column using master..spt_values?
  15. Splitting delimited values in a SQL column into multiple rows
  16. What does =* mean?
  17. SQL: parse the first, middle and last name from a fullname field
  18. varbinary to string on SQL Server
  19. SQL Select Upcoming Birthdays
  20. How can I include null values in a MIN or MAX?
  21. Stored procedure that exports data into csv files only exports to one file
  22. Get Start and End Date from Week Number SQL Server
  23. Get the last day of the month in SQL
  24. TSQL – How to use GO inside of a BEGIN .. END block?
  25. SQL take just the numeric values from a varchar
  26. SQL Server SELECT INTO @variable?
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Select a column if other column is null
  29. Date serial in SQL?
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment