What is a constraint. Types of constraints ?
Answer Posted / pavani
Constraint means it is rule which you want to apply on the
table. There are two types of constraints.
1. Column Constraints: Applicable for that column only.
2. Table Constraints: Applicable for more than one column.
Column Constraints:
a. unique b. not null c. primary key d. foreign key
e.default f. check
Table constraints:
a. unique b. primary key c. foreign key d. check
Is This Answer Correct ? | 26 Yes | 5 No |
Post New Answer View All Answers
What are the types of views in sql?
What is null in pl/sql?
What's the difference between inner join and left join?
what is user defined functions? : Sql dba
Is inner join faster than left join?
Are sql database names case sensitive?
Why do we need sharding?
What is interval partition?
What are different types of functions in sql?
What are sql triggers used for?
How do I run a pl sql program?
Why do we use sql constraints?
How can you save or place your msg in a table?
Can you upgrade sql express to full sql?
What is a boolean in sql?