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
- 9027 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 b tree index?
What is the difference between an index and a unique index?
What is global temp table?
What is Federation and Federation Member?
Which are the olap features?
What is the difference between mysql and mysqli?
Explain Normalization and DE normalization
What is data source view or dsv? : sql server analysis services, ssas
Why de-normalization required?
What is the library index called?
How to disconnect from a sql server using mssql_close()?
What does dml stand for?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is the maximum number of index per table?
How to find the source of a table in sql server?
