Collections:
CREATE INDEX - Adding an Index on an Existing Table in SQL Server
How To Create an Index on an Existing Table in SQL Server?
✍: FYIcenter.com
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
⇒ SP_HELP - Viewing Existing Indexes on an Given Table in SQL Server
⇐ What Are Indexes in SQL Server
2016-11-15, 3130🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...