Page 1 of 1
Unimetadata get tableist without system tables
Posted: Mon 10 Jan 2011 20:45
by rpijnacker
How to get list of tables with unimetadata without systemtables for
firebird and ms sql
Posted: Tue 11 Jan 2011 12:07
by AndreyZ
Hello,
You should add a restriction in the TUniMetaData.Restrictions list in the following way:
Code: Select all
UniMetaData.MetaDataKind := 'Tables';
UniMetaData.Restrictions.Add('TABLE_TYPE=TABLE');
UniMetaData.Open;
Posted: Tue 18 Jan 2011 06:13
by rpijnacker
OK this works
is it possible to see views and tables in one list?
i assume that table_type=VIEW will bring the views
Posted: Tue 18 Jan 2011 09:06
by rpijnacker
the view part works
what is the code for system tables?
Posted: Tue 18 Jan 2011 09:48
by AndreyZ
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.
Posted: Tue 18 Jan 2011 19:23
by rpijnacker
tnx
Posted: Wed 19 Jan 2011 09:45
by AndreyZ
Feel free to contact us if you have any further questions about UniDAC.