1) Union key -- Creates non clustered index by default.
-- Can be set as null
-- Can have multiple unique key
-- Can be referenced by a foreign key
2) Primary key
-- Creates clustered index by default.
-- Can't be set as null
-- Can have only single primary key
-- Can be referenced by a foreign key
-- Can be set as null
-- Can have multiple unique key
-- Can be referenced by a foreign key
2) Primary key
-- Creates clustered index by default.
-- Can't be set as null
-- Can have only single primary key
-- Can be referenced by a foreign key
No comments:
Post a Comment