How to get System Table names from a DataBase in ColdFusion

cfdbinfo - get system table name list from a datasource

cfdbinfoSystemTableList.cfm


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ColdFusion cfdbinfo tag example: how to get system table name list from a datasource</title>
</head>

<body>
<h2 style="color:DodgerBlue">ColdFusion cfdbinfo tag example: System Table List</h2>

<cfdbinfo datasource="cfartgallery" type="tables" name="qResult"> 
<cfquery dbtype="query" name="qSystemTableList">
 SELECT TABLE_NAME FROM qResult
    WHERE TABLE_TYPE='SYSTEM TABLE'
</cfquery>
<cfdump var="#qSystemTableList#">
</body>
</html>






More ColdFusion examples