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
what does the automatic recovery do? : Sql server administration
Define tool Manage Statistics in SQL Server 2000 query ?
can you instantiate a com object by using t-sql? : Sql server database administration
What is the use of @@spid?
How to receive output values from stored procedures?
What is the largest component inside a field?
Define master database?
Explain the phases a transaction has to undergo?
What is the use of sign function?
Write a sql query to display the current date?
What is the maximum size of column in sql server?
What command must you use to include the not null constraint after a table has already been created?
What is an expensive query?
What is the sql case statement used for?
What does Master database contains?