Subject Re: [firebird-support] SELECT COUNT(*) FROM :PARAMTABLE
Author Tanz Anthrox
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.

> We often see this coming from people who move from destop databases where
> they rely on record numbers a lot. In SQL dbs we do not rely on this as
part
> of operations.

I will put it only for statistical purposes.
And you caught me that I moved from Paradox Engine :) huh