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 optimization and its types?
Can you use order by when defining a view?
How can we get count of the number of records in a table?
How many types of triggers in sql server?
Does a full backup include transaction log?
Does the order of columns in update statements matter?
What is the temp table?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Can a rule be bound to any column of any data type?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
what stored procedure would you use to view lock information? : Sql server administration
How to execute a stored procedure in ms sql server?
What guidelines should be followed to help minimize deadlocks?
When would you use a before or after trigger?