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 / mohan

Constraint is nothing but set of rules or restrictions on a column,in order to achieve business requirements.

There are five types of constraints,
they are
1.primary key
2.unique key
3.not null
4.check
5.foreign key

These constraints also called data integrity constraints.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I clean up sql server transaction log?

1056


Indexes are updated automatically is the full-text index also updated automatically?

1013


Why transaction is important?

967


What is database replication?

1130


Explain about integration services of Microsoft SQL server?

1027


what is create database syntax? : Sql server database administration

1095


What are the instances when triggers are appropriate?

976


What are date and time data types in ms sql server?

1080


Differentiate between sql temp table vs table variable?

872


Explain logical operators in sql server?

1099


Why truncate is ddl command?

1054


Can we install sql server 2016 on windows 7?

1124


What is parameterized reports in ssrs ?

149


Explain what is “asynchronous” communication in sql server service broker?

906


Explain sub-query?

941