what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83653 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / m arunachalam
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).
We will focus on the following constraints:
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the syntax to execute the sys.dm_db_missing_index_details?
How to attach adventureworkslt physical files to the server?
What are dml triggers and types of dml triggers?
What is the difference between the 2 operating modes of database mirroring?
How to find related tables in sql server?
Do I need a report server to run reports in my application?
Can a database be shrunk with users active?
What do mean by xml datatype?
What are the different ways you can create databases in sql server?
What are indexes in sql?
What is self join in sql server joins?
Introduction of rollup clause using sum and group by clause?
Explain the difference between delete,drop and truncate in SQL Server?
What is normalization of database?
what is a live lock? : Sql server database administration
