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...

How will you a activate/deactivate integrity constraints?

Answer Posted / muralidhar v

To Activate any integrity constraint, use Enable command
with Alter and to deactivate use disable with Alter.

To drop any constraint other than NOT NULL, use Drop
command with Alter. We can't drop not null, but we can
change it to NULL with Alter --Modify option.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a function in oracle pl sql?

1043


What is keys and its types?

1077


Is sql dba a good career? : SQL DBA

996


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1064


What are tables in sql?

1070


Can cursors be part of a trigger body?

1641


What is the most common sql injection tool?

1044


what is a composite primary key ? : Sql dba

1055


What is string join?

981


What is sql server and ase?

1029


How can I see all tables in sql?

1078


Can I call a procedure inside a function?

1016


how can we optimize or increase the speed of a mysql select query? : Sql dba

949


What is sql character function?

1089


What is null in pl/sql?

1077