what is Constraint? How many types of constraints in SQL ?
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
Explain what is it unwise to create wide clustered index keys?
What do you understand by mirroring and mention the advantages of the mirroring?
What are the features of Embedded SQL
Explain having clause?
Give main differences between "Truncate" and "Delete".
Explain the properties of subqueries in sql server?
Which data type columns are the best candidates for full-text indexing?
Explain what is use of dbcc commands?
If no size is defined while creating the database, what size will the database have?
What are database states in ms sql server?
Explain transaction server consistency?
How to define the name and server for a new dsn?
Can the “if update (colname)” statement be used in a delete trigger?
How can I create a report based on a query? : sql server management studio
Is candidate a key?