Subject | Re: [firebird-support] SELECT COUNT(*) FROM :PARAMTABLE |
---|---|
Author | Tanz Anthrox |
Post date | 2004-02-12T11:32:23Z |
Thank you,
SELECT RDB$RELATION_NAME FROM RDB$RELATIONS
WHERE RDB$RELATION_NAME NOT LIKE 'RDB$%'
gives me Tables+Views, And I created
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE
(RDB$RELATION_NAME NOT LIKE 'RDB$%')
and
(rdb$view_source IS null)
gives me only tables.
And you caught me that I moved from Paradox Engine :) huh
SELECT RDB$RELATION_NAME FROM RDB$RELATIONS
WHERE RDB$RELATION_NAME NOT LIKE 'RDB$%'
gives me Tables+Views, And I created
SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE
(RDB$RELATION_NAME NOT LIKE 'RDB$%')
and
(rdb$view_source IS null)
gives me only tables.
> We often see this coming from people who move from destop databases wherepart
> they rely on record numbers a lot. In SQL dbs we do not rely on this as
> of operations.I will put it only for statistical purposes.
And you caught me that I moved from Paradox Engine :) huh