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
Do you know what are different types of replication in sql server?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Tell me the phases a transaction has to undergo?
Explain the stored procedure?
What are types of storage modes? : sql server analysis services, ssas
Explain the first normal form(1nf)?
What are the types of table?
Difference between connected and disconnected database in .net with sql server?
What are different types of constraints?
Explain cursor as data base object?
Define full outer join in sql server joins?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
List some advantages and disadvantages of stored procedure?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas