as an example, MySQL supports "SHOW FULL tables" sql statement, which will return all tables in this db associated with your sf dsn. however, you need to know the actual name of your mysql db to access the results of this query, because the name of the column which contains table names is TABLES_IN_[name-of-your-mysql-db-here] (without square brackets of course).
not sure if ms sql server has a similar sql statement it supports, but i suppose it does... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Azadi Saryev wrote: > which db are you using? > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > > BobSharp wrote: > >> Can I use CF 6.1 (including hot fixes) >> to see what tables are in the schema ? >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
