what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 79892 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / shelly
Constraints are used to limit the type of data that goes
into a table.Constraints can be declared at the time of
creating a table or by altering the already created table.
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References
6)Default
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What action plan is preferred if sql server is not responding?
What is difference between count (*) and count 1?
Differentiate between a primary key and a unique key.
Why can there be only one clustered index and not more than one?
How real and float literal values are rounded?
What is resource governor?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is meant by referential integrity?
Explain left outer join and right outer join?
What function does a database engine serve in the sql server?
What is the need for group functions in sql?
How to automatically create a log when an exception is being received into SQL Server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
what is a join? : Sql server database administration
How do you drop an index?
