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, 1416🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...