CREATE CLUSTERED INDEX - Adding Clustered Indexes in SQL Server

Q

How To Create a Clustered Index in SQL Server?

✍: FYIcenter.com

A

If there is no primary key in a table, you can add one clustered index to that table with CREATE CLUSTERED INDEX statement. The tutorial exercise below shows you how to create a clustered index:

USE FyiCenterData;
GO

-- Drop the old table, if needed
DROP TABLE fyi_links;
GO

-- Create a table with primary key
CREATE TABLE fyi_links (
  id INT,
  url VARCHAR(80) NOT NULL,
  notes VARCHAR(1024),
  counts INT,
  created DATETIME NOT NULL DEFAULT(getdate())
);
GO

-- Create a clustered index
CREATE CLUSTERED INDEX fyi_links_url ON fyi_links (url);
GO

-- Create a non-clustered index
CREATE INDEX fyi_links_created ON fyi_links (created);
GO

-- View indexes
EXEC SP_HELP fyi_links;
GO
index_name         index_description               keys
-----------------  --------------------------      ----
fyi_links_created  nonclustered located on PRIMARY created
fyi_links_url      clustered located on PRIMARY    url

 

Understanding and Managing Indexes in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-13, 683👍, 0💬