To create a clustered index by using Object Explorer
- In Object Explorer, expand the table on which you want to create a clustered index.
 - Right-click the Indexes folder, point to New Index, and select Clustered Index….
 - In the New Index dialog box, on the General page, enter the name of the new index in the Index namebox.
 - Under Index key columns, click Add….
 - In the Select Columns from table_name dialog box, select the check box of the table column to be added to the clustered index.
 - Click OK.
 - In the New Index dialog box, click OK.
 
- In Object Explorer, expand the database on which you want to create a table with a clustered index.
 - Right-click the Tables folder and click New Table….
 - Create a new table as you normally would. For more information, see Create Tables (Database Engine).
 - Right-click the new table created above and click Design.
 - On the Table Designer menu, click Indexes/Keys.
 - In the Indexes/Keys dialog box, click Add.
 - Select the new index in the Selected Primary/Unique Key or Index text box.
 - In the grid, select Create as Clustered, and choose Yes from the drop-down list to the right of the property.
 - Click Close.
 - On the File menu, click Save table_name.
 
To create a clustered index
- In Object Explorer, connect to an instance of Database Engine.
 - On the Standard bar, click New Query.
 - Copy and paste the following example into the query window and click Execute.
 
USE AdventureWorks2012; GO -- Create a new table with three columns. CREATE TABLE dbo.TestTable (TestCol1 int NOT NULL, TestCol2 nchar(10) NULL, TestCol3 nvarchar(50) NULL); GO -- Create a clustered index called IX_TestTable_TestCol1 -- on the dbo.TestTable table using the TestCol1 column. CREATE CLUSTERED INDEX IX_TestTable_TestCol1 ON dbo.TestTable (TestCol1); GO
No comments:
Post a Comment