Interested to Buy Any Domain ? << Click Here >> for more details...
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 is a view in sql?
When is the use of update_statistics command?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is extent? Types of extents?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How do I find the sql server instance name?
What is the openxml statement in sql server?
what is isolation level at dead lock?
Explain about integration services of Microsoft SQL server?
Characterize join and name diverse sorts of joins?
what is create database syntax? : Sql server database administration
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is a field name?
What is sub query and its properties?
How to disable triggers using "disable trigger"?
