Interested to Buy Any Domain ? << Click Here >> for more details...
1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;"
- 8 Answers
- 8899 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya
1)No We can't have more than 1 primary key. Even if you try
to save it will pop an error message and nothing will be stored.
2)Clustered Index is attached with Unique. A table can have
1 and only 1 Clustered Index and it will be mostly created
on the Primary Key of the Table.
Non Clustered can be up to 254(not sure about the
number)created for a single table.
3)You can definitely select from 2 tables but all the
columns will be merged. Please check how you want the data
from those 2 tables
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between locking and multi-versioning?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Difference between uniqe index and uniqe constraint?
How do I view views in sql server?
How can you append an identity column to a temporary table?
Does the unique constraint create an index?
How many types of subqueries are there in sql server?
Why use stored procedures in sql server?
Can an entity have two primary keys?
How to delete existing triggers using "drop trigger"?
Can you get second highest salary from the table?
What will be the maximum number of index per table?
What is spatial and temporal data?
How to create median function?
What is the difference between primary key and unique constraints?
