• Skip to primary navigation
  • Skip to content
  • Skip to footer
Sanjay Singh's Blog An another perspective
  • Home
  • Archives
    1. Home
    2. /
    3. 2011
    4. /
    5. 01
    6. /
    7. 07
    8. /
    9. Get all the columns of a given table in Firebird database

    Get all the columns of a given table in Firebird database

    January 07, 2011

    Following sql script gives all the columns of a given table (‘Employee’ in this example) in a Firebird database.

    SELECT Fields.RDB$FIELD_NAME "Column Name" FROM RDB$RELATION_FIELDS Fields
    WHERE Fields.RDB$RELATION_NAME = 'EMPLOYEE' and Fields.RDB$SYSTEM_FLAG = 0
    ORDER BY Fields.RDB$FIELD_POSITION
    

    Tags: Firebird

    Updated: January 7, 2011

    Share on

    Twitter Facebook LinkedIn
    Previous Next

    You May Also Enjoy

    Updating the Offline Code Editor: Preview and Live Share

    August 30, 2026

    Last April I wrote about an offline code editor — a stripped-down Monaco editor that stays in the browser and does not send your files anywhere. That post st...

    Cursor Control Plane, Rewritten on the Official SDK

    May 31, 2026

    In March I wrote about Cursor-ControlPlane — a way to drive Cursor CLI sessions on my own machine from a web dashboard or Telegram chat. The goal was the sam...

    Imprint: Styled Text on Images, Exported in the Browser

    April 15, 2026

    I built Imprint for a simple workflow: put styled text on top of a photo or graphic and download the result as PNG or JPG—without sending the image to a serv...

    Cursor-ControlPlane: Run Cursor CLI From Your Phone

    March 25, 2026

    I built Cursor-ControlPlane to control Cursor CLI sessions on my own machine from a web UI or a Telegram chat.

    • GitHub
    • Feed
    © 2026 Sanjay Singh's Blog. Powered by Jekyll & Minimal Mistakes.