Collections:
UNIQUE Constraint Creating Default Index in SQL Server
Does the UNIQUE Constraint Create an Index in SQL Server?
✍: FYIcenter.com
If you add the UNIQUE constraint on a column, SQL Server will automatically add a non-clustered index for that column. The tutorial exercise below shows you the index created as part of the UNIQUE column, "id", of "fyi_links":
USE FyiCenterData; GO -- Drop the old table, if needed DROP TABLE fyi_links; GO -- Create a table with a UNIQUE constraint CREATE TABLE fyi_links ( id INT UNIQUE, url VARCHAR(80) NOT NULL, notes VARCHAR(1024), counts INT, created DATETIME NOT NULL DEFAULT(getdate()) ); GO -- Create an index for column "url" CREATE INDEX fyi_links_url ON fyi_links (url); GO -- View indexes EXEC SP_HELP fyi_links; GO index_name index_description keys ----------------------- -------------------------- ---- fyi_links_url nonclustered located url on PRIMARY UQ__fyi_links__4222D4EF nonclustered, unique key located on PRIMARY id
Notice that the index created as part of the UNIQUE constraint is named by SQL Server as "UQ__fyi_links__4222D4EF".
⇒ Difference Between Clustered and Non-Clustered Indexes in SQL Server
⇐ Primary Key - Default Indexes of Tables in SQL Server
2016-11-13, 1427🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...