Newbie Questions for the Gurus.

[Sina]

Hello everyone.
I have couple of newbie questions, if you could kindly help.
here they are:
1. what is the command to get a list of the
database and tables in each database in Interbase?
2. How do I get a list of all the primary keys on a table ?
3. How do I get a list of all the foriegn keys on a table ?
4. How do I get a list of all the indexes on a table ?
5. How do I get a description on a table in Interbase(like field defenitions).
6. How do I find out the list of users with access to a specific table / database (get user privilages on each db)?
7. How do I get a list of all the valid table fileds TYPES in Interbase?
8. How to get a list of all Stor procs?
9. How can I list all views?
10 How to list functions in a database?

thank you all very much.

 

[svanels]

Use the IBConsole or a graphical utility like borlands sql-explorer, also there is the sql commandline utility that comes with interbase Steven van Els
SAvanEls@cq-link.sr

 

[Sina]

Thanks for the comment, but I have to do that without the Gui.

 

[tviohl]

You can get any meta information you want from the interbase/firebird system tables. Look what is in it and query it in SQL.

--
Thomas