Database Schema from the System Tables.......

Hi, If you are aware of, or use any SQL to extract the Schema information about a database from the system tables, can you send it to me. Objective : Iam trying to write a SP to drop and create tables owned by user "informix" , but they need to be dropped and recreated by another user. Unfortunatley the "SYSTEM" call inside a SP cannot be executed by a user who does have only the "EXECUTE" permission on the SP and hence can't run the dbschema to extract the schema dynamically. I am trying to get around this by extracting the schema from the system tables via a "SELECT" statement. Your inputs will be greatly appreciated. Thanks Abraham __________________________________ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com