SQL Index And Unique Index

Posted by Ranjeet_8 under Sql Server category on 8/30/2012 | Points: 40 | Views : 1897

Sql Index:


CREATE INDEX Name_OF_Index
ON Name_Of_Table (COlumn_Name1,Column_Name2,Column_Name3...);

Sql Unique Index:


CREATE UNIQUE INDEX Name_OF_Index
ON Name_Of_Table (COlumn_Name1,Column_Name2,Column_Name3...);

Bookmark It

Posted by: Pandians on: 8/13/2012 Level:Silver | Status: [Member] [MVP] | Points: 10

1. Give table structure
2. Please also specify what kind of Index you have created ? (Composite or Normal)

Latest Code Snipptes