How to extract the database metadata?

[Luciano Rodrigues Nunes Mendes]

Hi Guys,

Is there any possibility to extract the database metadata (DDL) using only the ADO.NET provider without needing isql.exe?

Thanks in advance,

Luciano

[Jiří Činčura]

You mean like `isql -x`? If so then the answer is no.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

[Mark Rotteveel]

On 23-05-2023 02:45, Luciano Rodrigues Nunes Mendes wrote:
> Is there any possibility to extract the database metadata (DDL) using
> only the ADO.NET provider without needing isql.exe?

There is nothing built in (not in Firebird, nor in the ADO.NET
provider), if that is what you're asking. ISQL itself generates the DDL
by querying the system tables. Currently, the only options are to build
it yourself or to see if anyone already wrote something like this.

I recently made a ticket to get this built-in in Firebird instead of the
current state of affairs that ISQL does it itself:
https://github.com/FirebirdSQL/firebird/issues/7584

Mark
--
Mark Rotteveel

[Luciano Rodrigues Nunes Mendes]

Hi Jiří and Mark,

Exactly! I asked if just as ado.net "replaces" fbclient.dll would it replace isql.exe as well. Good to know that there is already an open issue that will allow us to extract the metadata from the database without needing isql.exe: This is exactly what I need!

Best Regards,

Luciano 

--
You received this message because you are subscribed to the Google Groups "firebird-net-provider" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-net-pro...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-net-provider/6a46f5e3-0a4b-c69f-96d6-b4993985d9f8%40lawinegevaar.nl.