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, 1407🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...