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 Constraint? How many types of constraints in SQL ?

Answer Posted / seshu

constraint is a mechanism it is used to prevent the invalid
data entry in to the table is called constraint.
constraints are 5 types they are,

1 Primary Key Constraint
2 Foreign Key Constraint
3 Unique Constraint
4 Not Null Constraint
5 Check Constraint

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know clustered and non-clustered index?

979


what's the maximum size of a row? : Sql server database administration

1091


What is triggers in ms sql server?

1121


What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1171


How do I delete a sql server database?

1046


What is a primary key?

954


What is row-level compre?

1005


How can you tell if a database object is invalid?

1074


What is an example of a primary key?

993


What does it mean to be in union?

934


What is the difference between cartesian product and cross join?

867


How to generate create procedure script on an existing stored procedure?

1012


Give main differences between "Truncate" and "Delete".

1100


How do I shrink an ldf file?

980


What are the basic functions for master, msdb, model, tempdb and resource databases?

992