what is a constraint? Tell me about its various levels. : Sql dba
- 1 Answers
- 1082 Views
- I also Faced
- E-Mail Answers
Answer Posted / Anup Kumar Dwivedi
A constraint in SQL is a rule that ensures the integrity of data in a database. There are several types of constraints, including primary key, foreign key, unique, check, and default constraints. Primary and foreign keys ensure referential integrity, while unique and check constraints enforce specific conditions on columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use distinct and group by together?
what is dbms? : Sql dba
What is the best sql course?
what are the advantages of sql ? : Sql dba
what is schema? : Sql dba
what are aggregate and scalar functions? : Sql dba
what is sql server agent? : Sql dba
What is the current version of postgresql?
how to use regular expression in pattern match conditions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How do I remove duplicates in two columns?
If a cursor is open, how can we find in a pl/sql block?
what is collation? : Sql dba
Is inner join faster than left join?
What is the current version of sql?
