what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 84609 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / bimaleswar patel
Constraints are used to limit the type of data that can go
into a table.
two basic types of constraints are there
1.column level
2.table level
the difference is that column level constraints are apply
only to one column where as table level constraints are
apply to whole table
Constraints are declare at the time of table creation using
CREATE TABLE command
there are 6 constraints used in oracle
1.NOT NULL
2.UNIQUE
3.PRIMARY KEY
4.CHECK
5.DEFAULT
6.REFERENCES
| Is This Answer Correct ? | 96 Yes | 24 No |
Post New Answer View All Answers
How to insert a new row into a table with "insert into" statements in ms sql server?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is a join in sql?
How do you send email on SQL Server?
What are some examples of schemas?
What stored by the tempdb ? : sql server database administration
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to access the inserted record of an event?
Explain how many types of relationship?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is BCP? When does it used in sql server 2012?
How do I create a stored procedure in dbml?
How to turn on the mssql api module in php?
What is partition index in sql server?
