Re[2]: delete table
All,
I have played around with the system catalogs and encountered problems
doing it. What I was trying to do was change the nextsize in systables
with an update statement instead of using alter table. The update
worked ok but later I started to get problems because the information
stored at the ISAM level was different to the system catalogs.
With the statements below I believe that you would remove the logical
entry of the table from the system catalogs but the physical (at the
ISAM level) entry will still be there. This could lead to problems. If
you are going to try the suggestion below I would test it by following
the suggestions on a test database and running onchecks to confirm the
status of the database.
Regards
David Ashby
______________________________ Reply Separator _________________________________
The case of table that cannot be drop:
*** WARNING THIS PROCEDURE IS THE LAST RESORT ********
1) Logged in as informix or the owner of the database
2) Get the tabid of the table that is to be dropped.
3) delete these tabid in the system tables using query language.
ex. the tabid of the table that cannot be drop is 258.
run the sql in dbaccess.
delete from systables where tabid = 258;
delete from syscolumns where tabid = 258;
delete from sysindexes where tabid = 258;
delete from systabauth where tabid = 258;
delete from syscolauth where tabid = 258;
delete from sysviews where tabid = 258;
delete from syssynonyms where tabid = 258;
delete from syssyntable where tabid = 258;
delete from sysconstraints where tabid = 258;
delete from sysdefaults where tabid = 258;
delete from syscoldepend where tabid = 258;
delete from sysblobs where tabid = 258;
delete from sysopclstr where tabid = 258;
delete from systriggers where tabid = 258;
delete from sysdistrib where tabid = 258;
delete from sysfragments where tabid = 258;
YOU MUST BE LOGGED IN AS "informix" .
**** INFORMIX- The best RDBMS