What are constraints? Explain different types of
constraints?
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 to list all tables in the database using odbc_tables()?
Why the trigger fires multiple times in single login?
Explain use of expression builder.
how you can configure a running aggregate in SSRS?
List out the differences between global and local temp tables in sql server?
Explain steps of normalization?
How to insert data with null values?
How to delete duplicate rows from table except one?
What do you mean by sql server agent?
What do you understand by triggers?
Explain subquery and state its properties?
What do you understand by recursive stored procedure?
What is the importance of a recovery model?
What is query optimization process?
Write the SQL query to drop, truncate and delete table.