Collections:
CREATE CLUSTERED INDEX - Adding Clustered Indexes in SQL Server
How To Create a Clustered Index in SQL Server?
✍: FYIcenter.com
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
⇒ Creating an Index for Multiple Columns in SQL Server
⇐ Difference Between Clustered and Non-Clustered Indexes in SQL Server
2016-11-13, 1685🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...