How to get the creation date of a table on Firebird 2.5

106 views Asked by At

I'm using Firebird 2.5 and need to get the date of creation of a table.

SELECT DISTINCT RDB$RELATION_NAME
  FROM RDB$RELATION_FIELDS
 WHERE RDB$SYSTEM_FLAG=0;

I've tried with this table but there isn't any date field.

1

There are 1 answers

0
Mark Rotteveel On BEST ANSWER

You can't get the creation date of a table as this information is not recorded anywhere.