CODEWITHSUNDEEP
c#ado.netcompact-frameworkfirebird
hellboy
hellboy

Reputation: 1618

Query Firebird database schema with FirebirdClient

How can I query database schema in C#/ADO.NET/FirebirdClient? All classes in namespace Firebird.Data.Schema are internal.

For example: check if table has column with specified name query number of stored procedure parameters, its names and types

etc.

FirebirdClient - Compact Framework, NETProvider-2.5.2-CF.7z

Upvotes: 3

Views: 2269

Answers (2)

hellboy
hellboy

Reputation: 1618

I' ve got it!

    FbConnection connection = (FbConnection)this.GetConnection();
    connection.GetSchema("procedureparameters", new string[] { null, null, procedureName });

Also it possible to retrieve all information about database objects with FbConnection ::GetSchema

See also FbSchemaFactory::PrepareCollection

Upvotes: 1

Dennis
Dennis

Reputation: 37770

You should query system tables (their names are prefixed with RDB$):

How to get a list of tables, views and columns in Firebird database?
RDB$ system objects

Upvotes: 3

Related Questions