What are constraints? Explain different types of
constraints?
Answer Posted / henry
Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null
Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
What is the benefit of normalization?
What is policy based management (pbm)? : sql server database administration
What is pessimistic concurrency?
Do you know nested transaction?
What is a schema in ms sql server 2005?
How do I run sql server 2014?
What to check if a User database is locked?
Explain cross join or cartesian product in sql?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is data mart? : sql server analysis services, ssas
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Can two tables share a primary key?
Explain syntax for disabling triggers?
What is 2nf normalization form?
What are the indexes in sql server?