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