What is a constraint. Types of constraints ?
Answer Posted / samuvel
Constraint is a restriction on table
Types:
1)Column Constraints:applicable for column level
i)unique ii) not null
2)Table constraints:applicable for table level
1)primary key ii) foreign key d. check
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
How do I view a sql database?
What is the use of partition by in sql?
Are stored procedures faster than dynamic sql?
What is anonymous block in sql?
How exception is different from error?
Explain what is a field in a database and record in a database?
What is a pragma statement?
What is parallel hint?
Is pl sql useful?
How can you fetch common records from two tables?
Can a view be mutating? If yes, then how?
Who is the owner of mysql database?
Write a sql select query that only returns each name only once from a table?
what are date and time data types? : Sql dba
how can we submit a form without a submit button? : Sql dba