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

check, not null,unique

Answer Posted / prasanthi

Check Constraint:

The CHECK constraint is used to limit the value range that
can be placed in a column.

not null constraint:

if we give not null constraint to any column it will not
accept null values.

Unique Conatraint:

Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what does the automatic recovery do? : Sql server administration

958


Define tool Manage Statistics in SQL Server 2000 query ?

1020


can you instantiate a com object by using t-sql? : Sql server database administration

960


What is the use of @@spid?

954


How to receive output values from stored procedures?

1053


What is the largest component inside a field?

1025


Define master database?

983


Explain the phases a transaction has to undergo?

985


What is the use of sign function?

1030


Write a sql query to display the current date?

1027


What is the maximum size of column in sql server?

841


What command must you use to include the not null constraint after a table has already been created?

1046


What is an expensive query?

877


What is the sql case statement used for?

1031


What does Master database contains?

1079