Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88212 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 happens if you add a new index to large table?
How can you list all the columns in a database?
What do you understand by triggers?
Explain concepts of analysis services?
Where is my database stored on the hard disk in ms sql server?
what is a schema in sql server 2005? : Sql server database administration
List the types of recovery model available in sql server?
What is filter index?
Explain Capacity planning to create a database? and how to monitor it?
What is set nocount on and what is set nocount off?
What is compression - row-level and page-level compression?
What is buffer cash in sql server?
Define indexes?
Mention the different authentication modes in sql server.
How network traffic be reduced by using the stored procedure?
