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
Explain “@@rowcount” and “@@error” in sql server?
How to drop an existing stored procedure in ms sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What are subqueries in sql server? Explain its properties.
How use inner join in sql server?
What is the difference between ddl,dml and dcl commands?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Differentiate sql server reporting services vs. Crystal reports?
What is difference between createstatement and preparedstatement?
What is resource governor in sql server?
What is the maximum row of a size?
How can you insert values in multiple rows using one Insert statement?
What is an identity?
How many types of stored procedures are there in sql server?