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 are the different subsets of sql?
Explain the steps needed to create a scheduled job?
What is the difference between inner join and equi join?
How many types of attribute relationships are there? : sql server analysis services, ssas
What is the command dbcc checkdb used for?
sql server architecture ?
Define the term DML, DDL and DTL?
what is lazy writer?
Explain microsoft sql server functions?
What are the advantages of using third-party tools?
Can we rollback records deleted by a truncate statement?
3 Answers CarrizalSoft Technologies, United Healthcare,
What sql server means?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)