• 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

    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.

    Domain Finder: A Tool to Discover Available Domain Names

    March 20, 2026

    I’ve built Domain Finder—a tool to check domain availability and discover available domains. It uses RDAP to verify registration status.

    In-Browser GraphQL Playground

    September 17, 2025

    Hey folks!

    An Offline Code Editor

    April 5, 2025

    Hey everyone,

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