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 |
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
What is partition in sql server?
How you provide security to cube? : sql server analysis services, ssas
How to connect PK and FK?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is normalization of database?
Do you know how to store and query spatial data?
What are the advantages to use stored procedures?
How to transfer data from a cursor to variables with a "fetch" statement?
what is unique and xaml nonclustered index
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE
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)