• 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

    An Offline Code Editor

    April 5, 2025

    Hey everyone,

    Hash Generator: A Simple Browser Tool That Actually Respects Your Privacy

    April 4, 2025

    Hey folks! I just wrapped up another little weekend project - a browser-based Hash Generator. It’s super lightweight and lets you generate all sorts of crypt...

    Browser-Based Bitcoin Test Wallet

    April 1, 2025

    Hey everyone! I wanted to share a fun little project I’ve been tinkering with lately – a completely browser-based Bitcoin wallet that doesn’t need any server...

    Simple QR Code Generator: A Lightweight, Browser-Based Tool

    March 7, 2025

    Today, I’m sharing a simple yet effective tool I’ve developed: a browser-based QR Code Generator. In an era where QR codes have become ubiquitous, having a q...

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