What are constraints? Explain different types of
constraints?
Answer Posted / manish nagar
Constraints are used to limit the type of data that can go
into a table.
Constraints can be specified when a table is created (with
the CREATE TABLE statement) or after the table is created
(with the ALTER TABLE statement).
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What does dml stand for?
last function used in MS Access to convert sql what function will use in sql
What command is used to delete a table from the database in the sql server and how?
application server is slow what may be the problem
Explain what is the purpose of sql profiler in sql server?
Explain external key management in sql server 2008
Explain candidate key, alternate key, and composite key?
What is the difference between for trigger and after trigger?
What is a non-clustered index?
What is a linked server in sql server?
Which are ddl commands?
How to handle error or exception in sql?
What are the essential components of sql server service broker?
Difference between DELETE and TRUNCATE?
How to get a list all databases on the sql server?