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, 1505🔥, 0💬
Popular Posts:
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...