data block corruption

[SHE]

Hello to all.

I would like to ask if I drop an index with primary key, is the foreign keys attached to it will be dropped also? If so, how I can verify all the foreign keys attached to it & recreate it afterwards...

Many thanks,
she :)

[equipman]

For this matter, you will not succeed in dropping the primary key initially, as you have foreign keys attached to it. What you could do to identify the foreign keys is to run a select query to check for all tables with foreign key X, then drop the initial primary key X.

Hello to all.

I would like to ask if I drop an index with primary key, is the foreign keys attached to it will be dropped also? If so, how I can verify all the foreign keys attached to it & recreate it afterwards...

Many thanks,
she :)

[SHE]

For this matter, you will not succeed in dropping the primary key initially, as you have foreign keys attached to it. What you could do to identify the foreign keys is to run a select query to check for all tables with foreign key X, then drop the initial primary key X.

sir can you give me the commands to query all the foreign keys?

[milonov]

hi!
you can try to find tables that have foreign key to some approptiate table using query like:

select a.table_name,
a.constraint_na me pkey_constraint ,
a.r_constraint_ name
from user_constraint s a
where
a.constraint_ty pe = 'R'
and a.r_constraint_ name like '%YOUR_TABLE%'

usially r_constraint_na me consists table name as part of constraint name

Best regards,
Michael Milonov,
http://www.snotratech. com

sir can you give me the commands to query all the foreign keys?

[SHE]

Sir,

I run this command & no result found.

select a.table_name,
a.constraint_na me pkey_constraint ,
a.r_constraint_ name
from dba_constraints a
where
a.constraint_ty pe = 'R'
and a.r_constraint_ name like '%DIFFGENERICNB R%'

no rows selected

pls. advise.