Active Query Builder support area

Hide the schema and database name from the metadata tree structure

Avatar
  • updated
  • Completed

Hi All

 

I am using querybuilder control on my windows form. It should not show the database name and the schema tree nodes in the metadata pane. How can I configure it to show only tables and views directly.

 

Thanks.

 

Avatar
Robert Chan

Could someone please answer this question? 
I am specifying my own tables to show and its working but the database node is also showing as well. Could you please help?

Avatar
Andrey Zavyalov, PM

Hello, Robert and Rujua.

I am terribly sorry for not responding in time. If you don't get prompt answers to your questions in the Forum, please submit a private ticket.

The easiest way to do this is to set the QueryBuilder.MetadataStructureOptions.GroupByDatabases and GroupBySchemas properties to false.

Also, you can customize the Database Schema Tree the way you like. Read this article for details: Customizing the Database Schema Tree structure