What is Primary key and foreign key? Give an example
Answers were Sorted based on User's Feedback
Answer / vipin
Primary key which enforce the uniqueness in each row og table .
Foreign key win which the existing value in table must be there in other table .
diffrence is that PK does not allow Null Values anf FK allow null values
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / brajesh kumar srivastava
Primary key enforce uniqueness of column and deny to allow
null values to this column and enforce referential data
integrity constraint to other table column which is call
foreign key.
Foreign key column may contain null value
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / aaaaaaaaaaaaa
Primary key is a primary key that is an attribute.
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / alquama rizvi
MS-Access requires a special way of recognising every record of a table. For this you have to set or make a primary key. If you do not do so, MS-Access does this itself by adding a new field , serving as the primary key. A table may have only one primary key, although it may have more than one fields.
Is This Answer Correct ? | 0 Yes | 0 No |
Explain Different types of Projects?
How do you delete duplicate rows in sql server?
what is mean by crystal repoart? ahere we will mainly use that?
List out a number of the wants to setup a SQL Server failover cluster?
What are relationships and mention different types of relationships in the dbms
Can you explain powershell included in sql server 2008?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is normalization process?
How to list all stored procedures in the current database using ms sql server?
Explain error and transaction handling in sql server?
How do you use DBCC statements to monitor various aspects of a SQL server installation?
What is difference between order by and group by?