That...is an unbelievably helpful page and that query should be made
part of the official docs!
Daniel
On 3/23/2018 9:18 AM, [email protected] [firebird-support] wrote:
Daniel,
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.
https://www.alberton.info/firebird_sql_meta_info.html
HTH,
Edward
*From:* [email protected] <fire
[email protected]>
*Sent:* Thursday, March 22, 2018 7:53 PM
*To:* [email protected]
*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.
--
Daniel
