check, not null,unique
Answers were Sorted based on User's Feedback
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 |
What is the system function to get the current user's user id?
What are the source of constraints?
How can I know what locks are running on which resource?
What are exact numeric data types in ms sql server?
Tell me what is difference between view and materialized view?
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance
What is db stored procedure?
How many types of triggers in sql server?
What is a collation?
What stored procedure would you use to view lock information?
How to rebuild indexes with alter index ... Rebuild?
What are indexes in ms sql server?