urgent !!!!! some database admin problem

Hi all, I have some question as follows. 1) If there is a table A, I want to find what foreign key to relate to this table A since I want to disable the foreign key of the table concerned to do table reorganization? Because of using SAP, I don't know the whole database schema. How to find which table to relate to table A? 2) How to temporarily disable the foreign key of one table? 3) I use the SAP application but I really don't know the internal table relaionship. There is a case that I find a table with field type of text data type. However, I cannot find the BLOBspace have been created there. How can I check where this text data type data store? Can they store in ordinary DBspace? How to check it? Thank you very much in advance. Regards, Mike Ng

1) In dbaccess, you can find informix for table A. 2) set constraints,index for table_name disabled/enable 3) Yes, blobdata can be in ordinary dbspace where you create your table. Mike Ng wrote: > Hi all, > > I have some question as follows. > > 1) If there is a table A, I want to find what foreign key to relate to this > table A since I want to disable the foreign key of the table concerned to do > table reorganization? Because of using SAP, I don't know the whole database > schema. How to find which table to relate to table A? > > 2) How to temporarily disable the foreign key of one table? > > 3) I use the SAP application but I really don't know the internal table > relaionship. There is a case that I find a table with field type of text > data type. However, I cannot find the BLOBspace have been created there. How > can I check where this text data type data store? Can they store in ordinary > DBspace? How to check it? > > Thank you very much in advance. > > Regards, > Mike Ng

1) In dbaccess, you can find informix for table A. 2) set constraints,indexes for table_name disabled/enable 3) Yes, blobdata can be in ordinary dbspace where you create your table. Mike Ng wrote: > Hi all, > > I have some question as follows. > > 1) If there is a table A, I want to find what foreign key to relate to this > table A since I want to disable the foreign key of the table concerned to do > table reorganization? Because of using SAP, I don't know the whole database > schema. How to find which table to relate to table A? > > 2) How to temporarily disable the foreign key of one table? > > 3) I use the SAP application but I really don't know the internal table > relaionship. There is a case that I find a table with field type of text > data type. However, I cannot find the BLOBspace have been created there. How > can I check where this text data type data store? Can they store in ordinary > DBspace? How to check it? > > Thank you very much in advance. > > Regards, > Mike Ng