Unimetadata get tableist without system tables

rpijnacker · Post by **rpijnacker** » Mon 10 Jan 2011 20:45

How to get list of tables with unimetadata without systemtables for
firebird and ms sql

AndreyZ · Post by **AndreyZ** » Tue 11 Jan 2011 12:07

Hello,

You should add a restriction in the TUniMetaData.Restrictions list in the following way:

UniMetaData.MetaDataKind := 'Tables';
UniMetaData.Restrictions.Add('TABLE_TYPE=TABLE');
UniMetaData.Open;

rpijnacker · Post by **rpijnacker** » Tue 18 Jan 2011 06:13

OK this works

is it possible to see views and tables in one list?

i assume that table_type=VIEW will bring the views

rpijnacker · Post by **rpijnacker** » Tue 18 Jan 2011 09:06

the view part works

what is the code for system tables?

AndreyZ · Post by **AndreyZ** » Tue 18 Jan 2011 09:48

To obtain only system tables you should use the following code:

Code: Select all

UniMetaData.Restrictions.Add('TABLE_TYPE=SYSTEM TABLE');

Note that you can see all fields available in the TUniMetaData component. For that you should link the TUniMetaData component to the TDataSource and TDBGrid components.

rpijnacker · Post by **rpijnacker** » Tue 18 Jan 2011 19:23

AndreyZ · Post by **AndreyZ** » Wed 19 Jan 2011 09:45

Feel free to contact us if you have any further questions about UniDAC.