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
Can we use pragma autonomous_transaction in trigger?
What is oltp (online transaction processing)?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Why would you use sql agent?
What are the limitations/drawbacks or ssrs 2008 r2?
Explain the difference between delete,drop and truncate in SQL Server?
Explain about sql server login?
What is index fragmentation in ms sql server?
What sql server means?
What are the types of resultset?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Define model database?
Explain full-text indexing?
How can we call UDF(User Define Function) using C# code in ASP.net ?
can you implement data mining in SSRS?