Clave primaria de una tabla
¿Necesitan saber que campo es la clave primaria de una tabla?
Aquí les dejo el Script de como hacerlo:
USE BASE DE DATOS
GO
SELECT i.name AS IndexName, OBJECT_NAME(ic.OBJECT_ID) AS TableName, COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName FROM sys.indexes AS i INNER JOIN sys.index_columns AS ic ON i.OBJECT_ID = ic.OBJECT_ID AND i.index_id = ic.index_id and i.is_primary_key = 1 where OBJECT_NAME(ic.OBJECT_ID)= 'Clientes'
En este ejemplo el query me regresará la clave primaria de la tabla 'Clientes' .
En caso de que necesiten tener las claves primarias de TODAS las tablas de una base de datos solo es necesario quitar el ultimo renglón del query, así:
USE BASE DE DATOS
GO
SELECT i.name AS IndexName, OBJECT_NAME(ic.OBJECT_ID) AS ableName, COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName FROM sys.indexes AS i INNER JOIN sys.index_columns AS ic ON i.OBJECT_ID = ic.OBJECT_ID AND i.index_id = ic.index_id and i.is_primary_key = 1