Skip to content

Instantly share code, notes, and snippets.

@viniciusmelocodes

viniciusmelocodes/sql_fb_name_fields.sql

Created May 3, 2021 15:01
Download ZIP

Revisions

  1. viniciusmelocodes created this gist May 3, 2021.
    19 changes: 19 additions & 0 deletions sql_fb_name_fields.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,19 @@
    SELECT
    R.RDB$RELATION_NAME,
    R.RDB$FIELD_NAME,
    R.RDB$FIELD_SOURCE,
    F.RDB$FIELD_LENGTH,
    F.RDB$FIELD_TYPE,
    F.RDB$FIELD_SCALE,
    F.RDB$FIELD_SUB_TYPE
    FROM RDB$RELATION_FIELDS R
    JOIN RDB$FIELDS F ON
    F.RDB$FIELD_NAME = R.RDB$FIELD_SOURCE
    JOIN RDB$RELATIONS RL ON
    RL.RDB$RELATION_NAME = R.RDB$RELATION_NAME
    WHERE
    COALESCE(R.RDB$SYSTEM_FLAG, 0) = 0 AND COALESCE(RL.RDB$SYSTEM_FLAG, 0) = 0 AND RL.RDB$VIEW_BLR IS NULL
    AND R.RDB$FIELD_NAME LIKE '%PRAE_%'
    ORDER BY
    R.RDB$RELATION_NAME,
    R.RDB$FIELD_POSITION;