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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are constraints? Explain different types of
constraints?

Question Posted / manish nagar

Answer Posted / manish nagar

Constraints are used to limit the type of data that can go
into a table.

Constraints can be specified when a table is created (with
the CREATE TABLE statement) or after the table is created
(with the ALTER TABLE statement).

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2785

What are the types of subquery?

1042

What is report rendering ?

157

What is a deadlock and what is a live lock?

1003

What is use of except clause?

1092

What is difference between after and before?

1086

What do you understand by intent locks?

1012

How do you check sql server is up and running?

1001

Can you always create a cache of a report?

172

Write a sql query to display the current date?

1093

Explain transaction server distributed transaction?

980

what are constraints? : Sql server database administration

1056

what is difference between view and Dip.

2409

Can you explain various data region available in ssrs with their use?

976

How to concatenate two strings in SQL Server.

1149