SQL Server: Get table primary key using sql query [duplicate]

by

I also found another one for SQL Server:

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE OBJECTPROPERTY(OBJECT_ID(CONSTRAINT_SCHEMA + '.' + QUOTENAME(CONSTRAINT_NAME)), 'IsPrimaryKey') = 1
AND TABLE_NAME = 'TableName' AND TABLE_SCHEMA = 'Schema'

More Related Contents:

  1. How can I do an UPDATE statement with JOIN in SQL Server?
  2. The multi-part identifier could not be bound
  3. Subquery using Exists 1 or Exists *
  4. How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
  5. How can I query a value in SQL Server XML column
  6. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  7. SQL – How to store and navigate hierarchies?
  8. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  9. Update records in table from CTE
  10. INT vs Unique-Identifier for ID field in database
  11. SQL Server date format function
  12. Composite Primary key vs additional “ID” column?
  13. Can a sql server table have two identity columns?
  14. Saving changes after table edit in SQL Server Management Studio
  15. Eliminating duplicate values based on only one column of the table
  16. Logging ALL Queries on a SQL Server 2008 Express Database?
  17. SQL query to find Nth highest salary from a salary table
  18. How to get export output in “real” CSV format in SQL Server Management Studio?
  19. Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
  20. Get the records of last month in SQL server
  21. Log record changes in SQL server in an audit table
  22. Merge overlapping date intervals
  23. Script to save varbinary data to disk
  24. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  25. alternatives to REPLACE on a text or ntext datatype
  26. How can I backup a remote SQL Server database to a local drive?
  27. How to find out what is locking my tables?
  28. Add a column to existing table and uniquely number them on MS SQL Server
  29. What is the most appropriate data type for storing an IP address in SQL server? [duplicate]
  30. Executing SQL query on multiple databases

Leave a Comment