You can use dbschema statement to get information about a table

You can use the SQL dbschema statement to get information about table structures, views, synonyms and UDRs. This article describes how to use the dbschema statement to get this information.

Answer

INTRODUCTION

You can use the SQL dbschema statement to get information about table structures, views, synonyms and UDRs.

You can use the SQL dbschema statement to get this information:

tabname is the table name or "all" for all tables

synonyms created by the user name or "all" for all users

permissions granted to the user name or "all" for all users

procname is the stored procedure name or "all" for all stored procedures

dbname is the database name

filename is the name of the output file

DBSCHEMA Schema Utility INFORMIX-SQL Version 7.31.UD6W9
Copyright (C) Informix Software, Inc., 1984-1998
Software Serial Number RDS#R123456

create synonym "informix".syn1 for stores7demo:"informix".customer;

$ dbschema -t grupo_oper -p all -f sgc_var_param_var -d bhn dboutput.txt

DBSCHEMA Schema Utility INFORMIX-SQL Version 7.31.UD6W9
Copyright (C) Informix Software, Inc., 1984-1998
Software Serial Number RDS#R123456

create table "informix".grupo_oper
(
cod_gru_operat integer,
cod_operatoria integer
);
revoke all on "informix".grupo_oper from "public";

grant select on "informix".grupo_oper to "public" as "informix";
grant update on "informix".grupo_oper to "public" as "informix";
grant insert on "informix".grupo_oper to "public" as "informix";
grant delete on "informix".grupo_oper to "public" as "informix";
grant index on "informix".grupo_oper to "public" as "informix";

create procedure "informix".sgc_var_param_var( c char(30)) returning smallint;
-- created by valau
return 1;
end procedure;