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
How to get a list of columns in a view using the "sp_columns" stored procedure?
How to use old values to define new values in update statements in ms sql server?
what is difference between NULL and ISNULL in SQL Server 2008?
What are the two authentication modes in sql server?
Explain primary key?
What is an index. What are the types?
What are the different types of replication you can set up in sql server?
Explain what is the function of sql server agent windows service?
Difference between primary key and clustered index?
What is stored procedures?
How to select some specific columns from a table in a query in ms sql server?
What do you mean by subquery?
how many type of indexing in database?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How do you implement session management in SQL Server mode?