Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87984 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / adinarayana
COLUMN LEVEL
1.Column level constraints can be defined along with the
columns.
2.NOT NULL constraints can be defined at this level(to only
one column).
3.Composite keys can't be defined at this level
TABLE LEVEL
1.Table level constraints can be defined after defining the
all columns
2.NOT NULL constraints can't be defined at this level.
3.Composite key can be defined at this level
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to convert characters to times in oracle?
How do I uninstall oracle client from windows?
How to do a full database export?
What are the uses of linked server and explain it in detail?
What is merge statement used for?
please explain.. DB architecture ...
What is a relational database management system?
What is the difference between pre-select and pre-query?
What is Undo Management Advisor in Oracle?
How to define a variable to match a table column data type?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to convert dates to characters in oracle?
why dont we assign not null constraint as table level constraint.
How to get execution path reports on query statements?
How to write numeric literals in oracle?
