Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
table exists
- Thread starter Silvano
- Start date
You'd have to use something like ADO protocol or a CFX tag to accomplish this, depending on the database type you are querying.
CFHub.com - ADO Methods
CFX_GetTables
CFX_GetTables returns a comma-delimited list of table names from a given datasource.
- tleish
CFHub.com - ADO Methods
CFX_GetTables
CFX_GetTables returns a comma-delimited list of table names from a given datasource.
- tleish
There may be an easier way, depending on your database server. Check the ocumentation for your database server to see if there's a table in each database that describes the structure of the database. In SQL Server, it's a table called sysobjects, and it holds records describing all the tables, constraints, views, etc. You could query it like this:
In this case, I selected xtype='U' because I wanted user tables. Other values for xtype seem to be S for system table, P for stored procedures, V for views, PK for primary key constraints, and F for foreign key constraints.
Code:
<cfquery name="qryDBTables" datasource="myDSN" dbtype="ODBC">
SELECT name
FROM sysobjects
WHERE xtype='U'
</cfquery>- Status
Similar threads
- Locked
- Question