What is the difference between the Primary and Foreign key?

Answer Posted / suma

Primary key is unique index and non null coulum in a table.
While foreign key can have repeated values.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to convert numeric values to character strings? : Sql dba

558


What does over partition by mean in sql?

519


What is the current version of postgresql?

545


how can you see all indexes defined for a table? : Sql dba

528


What is the difference between pl and sql?

533






What is indexing in sql and its types?

533


What does sign mean sql?

559


Can sql function call stored procedure?

547


Is postgresql a nosql database?

518


what are numeric data types? : Sql dba

559


What are instead of triggers?

607


How many tables can a sql database have?

517


What do you mean by dbms? What are its different types?

546


How do you delete data from a table?

526


Does sql*plus have a pl/sql engine?

554