Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / c.jagadish
In sqlserver we have two types of indexes (1) Clustered (2)
non clustered indexes.
Indexes may be simple index or composite index.
Index formed based on single column values is called simple
index
index formed based on multiple column values is called
composite index.
Default index is NON CLUSTERED INDEX
When a table contains a primary key column then sqlserver
automatically creates a unique clustered index.
Unique--- automatically creates a non clustered index
so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT
NULL.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are commonly used mssql functions in php?
How to get a list of columns in a view using "sys.columns" in ms sql server?
what are defaults? : Sql server database administration
Explain how does the report manager work in ssrs?
How do I delete a sql server database?
Explain what is the main purpose of having conversation group?
Define synonym?
What is a filestream?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is a non clustered primary key?
What is Federation Root Database?
How to include text values in sql statements?
What is autocommit mode in sql server?
What are the different types of data sources in ssrs?
How to remove duplicate rows from table except one?
