Google
 

Jumat, 05 Oktober 2007

Firebird System Tables (Part IV)

The system table for stored procedure is like here. The purpose of this view is the same like in Firebird System Table (Part II).

CREATE VIEW "vSYS_FindProcSource"(
"procName",
"procSource")
AS
select r.rdb$procedure_name, r.rdb$procedure_source
from rdb$procedures r
where r.rdb$system_flag = 0;

Tidak ada komentar: