Table view with SQL Server 2005

Classic Servoy
1

Hello,
when creating a new form using as a server SQL Server 2005, the tables list is not only composed by the tables in the database, but also by other tables (views, in fact) of the master databes: all_, database_, xml_schema_*, etc.

It would be nice to filter all these views. And it would be even nicer if we could use a regular expression to filter the tables of the server view: for example, although I have other tables on the database, the only ones I want to use are the ones starting by tb_*.

Thank you,
Miguel.-

2

I’ve proposed a similar request on this thread:

3

It is the JDBC that Servoy uses, which can not see the difference between user tables and systemtables.

I posted already same situation and that was the reply of Servoy.

They don’t use (/want to use) specific coding for a certain database.

All passes by standard JDBC-calls which are valid for each type of database.

I agree with your request, but not much chance that Servoy is going to do something about this.