Subject | Re: [firebird-support] Some minor problem with metadata |
---|---|
Author | Pavel Menshchikov |
Post date | 2005-05-12T18:52:30Z |
Hello Antonis,
AT> Whenever I extract metadata I see thes tables in the produced SQL.
AT> CREATE TABLE IBE$AUTO_FIELDS
AT> CREATE TABLE IBE$CATEGS
AT> CREATE TABLE IBE$CHAMPS
AT> CREATE TABLE IBE$DOC
AT> CREATE TABLE IBE$DOC_ATTRIBUTS
AT> CREATE TABLE IBE$DOC_RELATIONS
AT> CREATE TABLE IBE$WORK_TABLES
AT> I can understand that these tables are of system type but I don't know
AT> if are Firebird needs them or are some tables trashed from ver 5, as
AT> they contain no data.
No, those are not system tables: system tables are with RDB$ prefix.
Is there a chance that you used IB Expert to administrate your
database? If yes, probably IB Expert offered you creating of the
tables and you agreed with that. (IB Expert uses IBE$ tables for
audit, etc.)
AT> What can I do to not see them?
If those tables are of IB Expert (select from them to find out what
the data is there), you may drop them. I don't know about relations
between them (FKs, etc.), so I can't tell you the order of dropping -
you need to define it yourself.
HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com
AT> Whenever I extract metadata I see thes tables in the produced SQL.
AT> CREATE TABLE IBE$AUTO_FIELDS
AT> CREATE TABLE IBE$CATEGS
AT> CREATE TABLE IBE$CHAMPS
AT> CREATE TABLE IBE$DOC
AT> CREATE TABLE IBE$DOC_ATTRIBUTS
AT> CREATE TABLE IBE$DOC_RELATIONS
AT> CREATE TABLE IBE$WORK_TABLES
AT> I can understand that these tables are of system type but I don't know
AT> if are Firebird needs them or are some tables trashed from ver 5, as
AT> they contain no data.
No, those are not system tables: system tables are with RDB$ prefix.
Is there a chance that you used IB Expert to administrate your
database? If yes, probably IB Expert offered you creating of the
tables and you agreed with that. (IB Expert uses IBE$ tables for
audit, etc.)
AT> What can I do to not see them?
If those tables are of IB Expert (select from them to find out what
the data is there), you may drop them. I don't know about relations
between them (FKs, etc.), so I can't tell you the order of dropping -
you need to define it yourself.
HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com