Subject Re: [firebird-support] Show Columns
Author Daniel Miller an unbelievably helpful page and that query should be made part of the official docs!


On 3/23/2018 9:18 AM, edmendeznc@... [firebird-support] wrote:



Not sure if this answers your question but I’ve had situations where I needed a way to get column details and table ddl within our application. We ended up creating a stored procedure that would return that information.


The following linked helped me with understanding what needed to be done in order to create that stored procedure.






From: <fire>
Sent: Thursday, March 22, 2018 7:53 PM
Subject: [firebird-support] Show Columns



Using some system table queries, is there a view or stored procedure that
can, in "full", replicate the output of "show columns from table" available
from other servers?

Ideally this would be a "drop in" alternative to the "show columns" sql
statement that returns the same data in the same structure.

There are a few examples I can draw from, including firebirdwebadmin, but I
don't want to reinvent it if I don't have to.