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
How many types of sql are there?
how to convert dates to character strings? : Sql dba
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
tell us something about heap tables. : Sql dba
What are the types of join in sql?
how to convert character strings to numeric values? : Sql dba
How is data stored on a disk?
what is collation? : Sql dba
Explain the methods used to protect source code of pl/sql.
Why we use joins in sql?
How many types of tables are there?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is left join in sql?
what are the different functions in sorting an array? : Sql dba
What is form and report?