I have a problem with a lot of tables being seen in the Table list in a SQL Query templates.
Connector: Sql Connector
Database: Sql Database on SQl server 2005
I open a SQL Query template, choose the conector and mode Fixed query. when I switch to the Fixed query tab i find a huge list of system tables views along with the tables in the database connector is pointing to.
This makes the developers task tough as he has to search for one or two tables in a list of 30 or 40 tables.
Many should have faced this problem. could you enlighten with the solution/work around.
Any help in this regard is appriciable.
A Prashant Kiran