Database - SQL Server 2000 - Discussion
Discussion Forum : SQL Server 2000 - General Questions (Q.No. 17)
17.
SQL Server automatically creates an index on:
Discussion:
8 comments Page 1 of 1.
Yogi said:
5 years ago
Automatically generate an index on primary & unique key only.
Dipali said:
9 years ago
Answer C is wrong. The correct answer is A.
Here, sp_help table name: Just try this with your table that has a primary key and foreign key. It will show you 'clustered index' on the primary key and 'No Action' on foreign key clustered index automatically generated through the system when you set primary key to your table.
Here, sp_help table name: Just try this with your table that has a primary key and foreign key. It will show you 'clustered index' on the primary key and 'No Action' on foreign key clustered index automatically generated through the system when you set primary key to your table.
Prashant said:
9 years ago
The index is not generated by default in Foreign key, it is generated only in the primary and unique key.
Nitin Pant said:
10 years ago
We can assume primary key generated by default cluster index by system.
But foreign key is not possible system auto generate index.
But foreign key is not possible system auto generate index.
Rohit said:
1 decade ago
Its not possible that any index in SQL creates itself. Its wrong if any one can explain please do it.
Ronak said:
1 decade ago
We can assume primary key automatically generated by system for its own reference,
But though foreign key is not possible system auto generate.
But though foreign key is not possible system auto generate.
Nitesh said:
1 decade ago
How option C? It must be option D....how sql server automatically create an index? please explain
Ian s said:
1 decade ago
This is wrong. An index is not created on a Foreign Key by default.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers