WINDOWS

C:\Archivos de programa\firebird\Firebird_3_0 > isql

SQL> create database "C:\Temp\ferreteria.gdb" ;

SQL> connect C:\Temp\ferreteria.gdb;

SQL> quit;

C:\Archivos de programa\firebird\Firebird_3_0 > isql -u SYSDBA -p masterkey -i C:\Temp\ferreteria.sql -o C:\Temp\salida.txt

C:\Archivos de programa\firebird\Firebird_3_0 > isql -u SYSDBA -p masterkey 

SQL> CONNECT c:\TEMP\FERRETERIA.GDB ;

SQL> show system ;

SQL> show tables ;

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


RDB$RELATION_NAME	CHAR(31)	Table or view name
RDB$SYSTEM_FLAG	SMALLINT	indicates whether the table or view is user-defined (value 0) or system-defined (value 1 or greater)
RDB$RELATION_FIELDS stores the definitions of table and view columns.


SQL>SELECT RDB$FIELD_NAME FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME='ARTICULO';

RDB$FIELD_NAME	CHAR(31)	Column name


SQL> select count(*) from RDB$PROCEDURES ;

RDB$PROCEDURES stores the definitions of stored procedures, including their PSQL source code and the binary language representation (BLR) of it. The next table, RDB$PROCEDURE_PARAMETERS, stores the definitions of input and output parameters.

SQL> show procedures;

SQL> select RDB$PROCEDURE_name from RDB$PROCEDURES ;

SQL> select RDB$procedure_source from RDB$PROCEDURES where RDB$PROCEDURE_name = 'SP_MOV_FAC';

SQL> select RDB$TRIGGER_source from RDB$TRIGGERS where RDB$TRIGGER_name = 'TRG_BDFACTURA';

---------------------------------------

SQL> select count(*) from RDB$TRIGGERS where rdb$trigger_type = 1 and rdb$system_flag = 0 ;

rdb$trigger_type = 1  de before insert
rdb$system_flag = 0  indicates whether the trigger is user-defined (value 0)


SQL> select rdb$trigger_type, rdb$trigger_name from RDB$TRIGGERS ;

rdb$trigger_type
1 - before insert
2 - after insert
3 - before update
4 - after update
5 - before delete
6 - after delete
17 - before insert or update
18 - after insert or update
25 - before insert or delete
26 - after insert or delete
27 - before update or delete
28 - after update or delete
113 - before insert or update or delete
114 - after insert or update or delete
8192 - on connect
8193 - on disconnect
8194 - on transaction start
8195 - on transaction commit
8196 - on transaction rollback

SQL> select rdb$trigger_type, rdb$trigger_name from RDB$TRIGGERS where rdb$trigger_type = 1;

SQL> select rdb$trigger_type, rdb$trigger_name from RDB$TRIGGERS where rdb$trigger_type = 1 and rdb$system_flag = 0 ;

SQL> select rdb$trigger_type, rdb$trigger_name from RDB$TRIGGERS where rdb$trigger_type = 1 and rdb$system_flag = 1 ;

SQL> select rdb$trigger_type, rdb$trigger_name from RDB$TRIGGERS where rdb$trigger_type = 1 and rdb$system_flag = 3 ;

9.7

SQL> select rdb$trigger_type, rdb$trigger_name from RDB$TRIGGERS where rdb$relation_name = 'FACTURA' AND RDB$SYSTEM_FLAG = 0;

9.8

SQL> select rdb$user, rdb$privilege , rdb$relation_name FROM rdb$user_privileges where rdb$user = 'SYSDBA' and rdb$relation_name = 'FACTURA' ;

9.9

SQL> SELECT RDB$EXCEPTION_NAME , RDB$message FROM RDB$EXCEPTIONS WHERE RDB$SYSTEM_FLAG = 0 AND RDB$message LIKE '%Factura%' ;

9.10

hacer
 ----------------------------------------------------------------

10.
  SI !!  Catalogo (CBD). Obtener el script usando isql  con el switch -ex "-ex" significa extract metadata combinalo con -o miscript.txt
ej:
isql -d C:\temp\ferreteria.gdb -u sysdba -p masterkey -r sysdb -ex -o C:\temp\miscript.sql