Halo Martijn,

Pada 04 Januari 2006, 19:38:09, Anda menulis:

> All this info is available in the system tables, contained in each Firebird
> database.

> Tables and Views can be found in RDB$RELATIONS --

> Tables:

> select *
> from rdb$relations
> where rdb$view_blr is null

> Views:

> select *
> from rdb$relations
> where rdb$view_blr is not null

> Filter system tables by doing:
> and rdb$system_flag is null or rdb$system_flag = 0

> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com

Thanks, very helpful.

--
Best regards,
Andi Wangsadijaya

Send instant messages to your online friends http://asia.messenger.yahoo.com