When you don't have DB access, but need to see the tables & field names with which you are working.

inspectAllTables.cfm

<!--- change datasource as needed --->
<cfset thisDatasource = "example">

<!--- retrieve and display all table names in order --->
<cfquery name="getAllTableNames" datasource="#thisDatasource#">
  SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
    ORDER BY Table_Name
</cfquery>
<cfdump var="#getAllTableNames#" label="getAllTableNames" expand="false">

<!--- show one record from each table, provide insight into its structure --->
<cfloop query="getAllTableNames">
  <cfquery name="thisTable" datasource="#thisDatasource#">
    SELECT TOP 1 * FROM #table_name#
  </cfquery>
  <cfdump var="#thisTable#" label="#table_name#" expand="true">
</cfloop>