check, not null,unique

Answers were Sorted based on User's Feedback



check, not null,unique..

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

check, not null,unique..

Answer / chaitu

These are contraints

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,


How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  


Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  


What is user-defined inline table-valued function?

0 Answers  


How can you stop stored procedures from recompiling?

0 Answers  






What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  


What is the maximum size of a row in sql server?

0 Answers  


How to convert character strings into numeric values?

0 Answers  


How to specify the collation for a character data type in ms sql server?

0 Answers  


How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  


What are functions in the sql server?

0 Answers  


one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  


Categories