GeekInterview.com
Series: Subject: Topic:
Question: 6 of 444

Constaints

What are the different types of constraints ? Difference b/w unique and not null constraints?
Asked by: upendarkm | Member Since Apr-2012 | Asked on: Apr 26th, 2012

View all questions by upendarkm

Showing Answers 1 - 2 of 2 Answers
suresh

Answered On : May 4th, 2012

Constrain is nothing but it is an condition, it is might be any type of condition. and second one is unique and not null means unique is maintain one record do not accept duplicate record . not null means it is an datatype constraint in the particular column does not accept any null values should be need a value in that field.

  
Login to rate this answer.
SURESH

Answered On : May 6th, 2012

Constraints are used for filter the data as transformer stage and from in sql different type of constrains having null, isnull, primarykey,foreign key and unique constrains Ans unique constrain is not allowed duplicate values and Notnull constrain means should be having a data in that column.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.