• 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

    Offline PDF to Markdown

    October 17, 2026

    One use case I keep running into: I get a PDF, I need to change a few things, and then I want some analysis of it.

    Twinweather: Celsius and Fahrenheit on the Same Screen

    October 11, 2026

    I wanted a weather page that shows Celsius and Fahrenheit at the same time. I also wanted the name of a day to mean the daytime.

    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...

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