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
what are the join types in tsql? : Transact sql
What are the three pl sql block types?
What is mutating trigger?
What is trigger with example?
Explain the significance of the & and && operators in pl sql.
What is the difference between execution of triggers and stored procedures?
What is sql lookup?
how can you see all indexes defined for a table? : Sql dba
Enlist the data types that can be used in pl/sql?
What is a pl/sql block?
Which one is better subquery or joins?
What is the difference between delete and truncate commands?
Can we insert data in view?
Can we join two tables without common column?
What is difference between primary and secondary key?