Subject | Re: Large row count in tables |
---|---|
Author | roar4711 |
Post date | 2009-08-05T12:35:56Z |
--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...> wrote:
RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
RDB$TRIGGERS
RDB$TRIGGERS
RDB$RELATIONS
RDB$RELATIONS
RDB$GENERATORS
RDB$RELATION_CONSTRAINTS
RDB$RELATION_CONSTRAINTS
RDB$RELATION_CONSTRAINTS
RDB$RELATION_CONSTRAINTS
RDB$REF_CONSTRAINTS
RDB$REF_CONSTRAINTS
RDB$CHECK_CONSTRAINTS
RDB$CHECK_CONSTRAINTS
RDB$CHECK_CONSTRAINTS
RDB$INDEX_SEGMENTS
RDB$INDEX_SEGMENTS
RDB$INDICES
RDB$INDICES
RDB$TRIGGERS
RDB$TRIGGERS
RDB$RELATION_FIELDS
RDB$RELATION_FIELDS
RDB$RELATION_FIELDS
RDB$PROCEDURES
RDB$PROCEDURES
RDB$EXCEPTIONS
RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
RDB$RELATION_CONSTRAINTS
RDB$CHECK_CONSTRAINTS
RDB$FIELDS
But I guess those are there for a reason ?
>When I look in RDB$TRIGGERS this is the only thing:
> roar4711 wrote:
> > Thats the weird thing, I got no triggers at all
>
> Maybe you have database triggers (on transaction start, etc.) ?
>
> Or maybe the target table has some check constraint with a select
> statement, or a computed column that does select in turn?
>
> --
> Milan Babuskov
RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
RDB$TRIGGERS
RDB$TRIGGERS
RDB$RELATIONS
RDB$RELATIONS
RDB$GENERATORS
RDB$RELATION_CONSTRAINTS
RDB$RELATION_CONSTRAINTS
RDB$RELATION_CONSTRAINTS
RDB$RELATION_CONSTRAINTS
RDB$REF_CONSTRAINTS
RDB$REF_CONSTRAINTS
RDB$CHECK_CONSTRAINTS
RDB$CHECK_CONSTRAINTS
RDB$CHECK_CONSTRAINTS
RDB$INDEX_SEGMENTS
RDB$INDEX_SEGMENTS
RDB$INDICES
RDB$INDICES
RDB$TRIGGERS
RDB$TRIGGERS
RDB$RELATION_FIELDS
RDB$RELATION_FIELDS
RDB$RELATION_FIELDS
RDB$PROCEDURES
RDB$PROCEDURES
RDB$EXCEPTIONS
RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
RDB$USER_PRIVILEGES
RDB$RELATION_CONSTRAINTS
RDB$CHECK_CONSTRAINTS
RDB$FIELDS
But I guess those are there for a reason ?