GrokFusebox

Get SQL Server list of tables for your current db
This will generate a list of all the tables in your specified DB on SQL Server

<CFQUERY name="getTables" datasource="#dsdata#">
Select name
From systables
Where xType = u
</CFQUERY>

<CFSET tableList= valueList(getTables.name)>