#primarykey

[fortunatelycoldengineer]

Super Key . . . for more information http://bit.ly/3SRCeGD check the above link.

[fortunatelycoldengineer]

Candidate day . . . for more information http://bit.ly/3SRCeGD check the above link.

[fortunatelycoldengineer]

Primary Key . . . for more information http://bit.ly/3SRCeGD check the above link.

[ssrverse]

In SQL Server, we have two keys - primary key and unique key which distinctively or uniquely identify a record in the database. Both the keys seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and unique key.

[onlinesoftwaretrainings]

Primary (PK) and Foreign Key (FK) Relation on Table without Cascade Rule

[essie654-blog]

Primary Key & Foreign Key - How to differ each other In SQL Server Foreign key as same as Primary key both are Unique. Both are identified uniquely in each table but their characteristics are different. For more Info click here. More info

[squl-blog]

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