Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Where not exists in sql?

1032


What are sql constraints?

1228


Is sql workbench free?

1047


What is a file delimiter?

1164


How would you convert date into julian date format?

1044


What is out parameter used for eventhough return statement can also be used in pl/sql?

1126


Explain the types of joins in sql?

1075


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273


How do I create a sql script?

1142


When is a declare statement required?

1197


What are the key differences between SQL and PL SQL?

1286


Are subqueries faster than joins?

1076


How can you fetch common records from two tables?

1106


What do you mean by rowid?

1024


What is a primary key? Explain

1028