what is Constraint? How many types of constraints in SQL ?
Answer Posted / balamurugan
only five constraint in sql server
Types of Constraints are:
1)Not Null
2)Unique
3)Foreign Key
4)Check
5)Default.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between varchar and varchar(max) datatypes?
What are the diifferences between the ms sql server vs mysql?
What is the difference between TRUNCATE and DROP?
Why I have to use stored procedures?
How to backup encryption key ?
What are transactions in sql?
What is resource governor in sql server?
What is model database? : SQL Server Architecture
Explain the creation and execution of a user-defined function in the sql server?
Is null vs coalesce?
Explain in brief how sql server enhances scalability of the database system?
What are the advantages of mirroring?
Explain the ways to controlling cursor behavior?
What is compression - row-level and page-level compression?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration