Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 90785 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
How do you start single user mode in clustered installations?
How can you control the amount of free space in your index pages?
What is BCP? When does it used in sql server 2012?
How to automatically create a log when an exception is being received into SQL Server?
What is the difference between system objects and user objects?
What are different types of raid levels?
What is snapshot replication?
Why use “pivot” in sql server?
Which data type columns are the best candidates for full-text indexing?
What the different components in replication and what is their use?
What are secondary xml indexes?
What will be the maximum number of indexes per table?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What is difference between equi join and natural join?
What are the character string functions supported by sql server 2005?
