CREATE INDEX - Adding an Index on an Existing Table in SQL Server

Q

How To Create an Index on an Existing Table in SQL Server?

✍: FYIcenter.com

A

If you want to an index on an existing table, you can use the CREATE INDEX statement in a simple syntax:

CREATE INDEX index_name ON table_name (column_name)

The tutorial exercise below shows you how to add an index for the "in" column of the "fyi_links" table:

USE FyiCenterData;
GO

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

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

-- Create an index for "id"
CREATE INDEX fyi_links_id ON fyi_links (id);
GO

-- Create an index for "url"
CREATE INDEX fyi_links_url ON fyi_links (url);
GO

 

Understanding and Managing Indexes in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-15, 746👍, 0💬