is there more the two primary key in a single table?
Answers were Sorted based on User's Feedback
Answer / sathishrpillai
no, but there can be any number of forgein keys in a single
table.
A primary key of one table is the forgein key for other
table.
Is This Answer Correct ? | 4 Yes | 2 No |
No it is not possible.
A table has only one primary key
If the table has more than one primary key is called
composite key.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / navaneethakrishnan
no we cannot,
but we can do composite key in sql2005,
go in enterprise manager...
in the design view first set the primary key to one field
and then press ctrl key and set primary key to another field..
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sudheer gowlikar
we cannot have more than one primary key on a table since
primary will create a clustered index and we can have only
1 clustered index on a table since clustered index will
sort data in data pages and the data sorted in one way
rather sorting number of ways.
Is This Answer Correct ? | 2 Yes | 0 No |
If table has more than one primary key is called
composite key....
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vincent
create table StudMaster(studid int not null,studname varchar
(20) not null,constraint Studmaster primary key clustered
(studid,studname))
Is This Answer Correct ? | 0 Yes | 0 No |
Explain microsoft sql server functions?
What are clustered and non-clustered index?
Disadvantages of the indexes?
What are the built in functions in sql server?
What are different types of join?
How many types of indexes are there in SQL Server?
6 Answers CarrizalSoft Technologies, United Healthcare,
What is difference between restoration and recovery in SQLServer?
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,
What are the different types of backups avaialabe in sql server 2005?
What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
How do I find sql server instance name?