What is a constraint. Types of constraints ?

Answer Posted / sohail

Constraint is a restriction on table.There are two types of
constraints 1.ananymous constraint and 2.named
constraint.under named and ananymous constraints there are
1.primary key constraint
2.foreign key constraint
3. not null constraint
4. check constraint
5. unique constraint.

Is This Answer Correct ?    40 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I write a cron which will run a sql query and mail the results to agroup?

531


What is embedded sql what are its advantages?

509


What is a left inner join?

544


What is the max nvarchar size?

525


how to create a new table by selecting rows from another table in mysql? : Sql dba

565






What is scalar function in sql?

536


What's the difference between a primary key and a clustered index?

522


Can a trigger call a stored procedure?

541


how to present a past time in hours, minutes and seconds? : Sql dba

570


Can we edit a view in sql?

558


What is a sql*loader control file?

622


What language is oracle sql developer?

514


What is error ora-01000: maximum open cursors exceeded

606


What is sql*plus?

575


What are the different dml commands in sql?

592