What are primary keys and foreign keys?
Answers were Sorted based on User's Feedback
Answer / nevual
Primary keys are the unique identifiers for each row. They
must contain unique values and cannot be null. Due to their
importance in relational databases, Primary keys are the
most fundamental of all keys and constraints. A table can
have only one Primary key.
Foreign keys are both a method of ensuring data integrity
and a manifestation of the relationship between tables.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sudarsan
Primary key is a unique id for each table. This prevents
duplication of records. Each table can have a single
primary key. They can be refrenced by any tables as a
foreign key.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / jai prakash chauhan
Primary keys are by default clustered index.
| Is This Answer Correct ? | 3 Yes | 2 No |
• Primary Key: A unique identifier for a table’s record (e.g., id in a table).
• Foreign Key: A column in a table that refers to the primary key of another table, establishing a relationship between tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Tell me what are the advantages of using stored procedures?
What is a partitioned view?
How to view the error log for any specific instance? : sql server database administration
What stored procedure would you use to view lock information?
Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query
Define right outer join?
What is multilevel indexing?
how do we find every fifth record in a table
How to Install SQL SERVER 2005 remotely?
Explain the phases a transaction has to undergo?
Please tell me some knowledge about Clustering and how to add clustering?
How to Check if table exists in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)