Search notes:

SQL Server: Primary Key constraint

See also

Using the identity function to fill primary key values with unique values.
sys.key_constraints
Type PK in sys.objects
Table constraints

Index