Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between column level constraints and
table level constraints?

Answer Posted / rajan sharma

Column level are those constraints that are inserted after
the declaration of the data typeot

Syntax :

CREATE TABLE table_name
(Column_name Datatype NOT NULL )

Example : Not null,pimary key,foreign key, unique and check.

Table level constraints are those that are inserted at the
end of the table.

Example : pimary key,foreign key, unique and check.

Thanks

Is This Answer Correct ?    21 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle server autotrace in oracle?

1219


How are extents allocated to a segment?

1177


What are the limitations oracle database 10g xe?

1089


State the various uses of dbcc command?

1102


What are the built-in functions used for sending Parameters to forms ?

3430


master table and child table performances and comparisons in Oracle ?

2194


Give the various rollback segment states.

1083


What is difference between truncate and delete?

1089


How to call a stored function with parameters?

1089


How to best split csv strings in oracle 9i?

1091


What are the execution control statements?

1107


How to change program global area (pga) in oracle?

1144


What is the difference between primary key and unique key and foreign key in oracle?

1029


What is a proxy object?

1102


How to connect ms access to oracle servers?

1056