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 exactly sql injuction.how to overcome.....
How do we know if any query is retrieving a large amount of data or very little data?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What is user-defined inline table-valued function?
How can you stop stored procedures from recompiling?
What is difference in performance between insert top (n) into table and using top with insert?
What is the maximum size of a row in sql server?
How to convert character strings into numeric values?
How to specify the collation for a character data type in ms sql server?
How to list all triggers in the database with sys.triggers in ms sql server?
What are functions in the sql server?
one table has four field id,name,design,salary. i have to find maximum salary .