What are constraints? Explain different types of
constraints?
- 26 Answers
- 132259 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
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
How do we Backup SQL Azure Data?
What is a filestream?
What do you understand by a stored procedure?
What are diverse clauses that form a part of sql?
What are the disadvantages of primary key and foreign key in SQL?
What is a natural primary key?
What are the different types of lock modes in sql server 2000?
What do you know about system database? : SQL Server Architecture
Can you move the resources after pausing the node? : sql server database administration
what are the three command line utilities and what are their primary functions?
How can a database be repaired?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
When do you think a developer should use sql server-based cursors?
What does it mean to normalize a database and why would you do it?
What are the character string functions supported by sql server 2005?
