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 / rehan khan

constraint enforces rules at the table level and prevent the deletion of a table if there are dependencies .

constraint type:

primary key
foreign key
unique
not null
null
check
constraints can be defined at the time of table creation or after table has been created.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the properties of the transaction?

1052


Which is the best place or learning center for MS SQL?????In Bangladesh?????

2112


How can we rewrite sub-queries into simple select statements or with joins?

1029


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1137


What is the use of commit?

1061


Can you pass expressions to function parameters?

1154


How to skip remaining statements in a loop block using continue statements?

1043


What is triggers and its types?

1067


What is db stored procedure?

943


You want to implement the one-to-one relationship while designing tables. How would you do it?

1014


How do I find query history in sql server?

989


What are data driven subscriptions?

115


How do you open a cluster administrator?

1097


How to create a view on an existing table in ms sql server?

1193


What is a dbms wizard?

1074