cfdbinfo

Lets you retrieve information about a data source, including details about the database, tables, queries, procedures, foreign keys, indexes, and version information about the database, driver, and JDBC

 <cfdbinfo type="Columns" name="">

 cfdbinfo(type="Columns", name="");

cfdbinfo Attribute Reference

type
Required
Default: Tables

Type of information to get:

* dbnames: database name and type
* tables: name, type, and remarks
* columns: name, SQL data type, size, decimal precision, default value, maximum length in bytes of a character or integer data type column, whether nulls are allowed, ordinal position, remarks, whether the column is a primary key, whether the column is a foreign key, the table that the foreign key refers to, the key name the foreign key refers to
* version: database product name and version, driver name and version, JDBC major and minor version
* procedures: name, type, and remarks
* foreignkeys: foreign key name and table, primary key name, delete and update rules
* index: name, column on which the index is applied, ordinal position, cardinality, whether the row represents a table statistic or an index, number of pages used by the table or index, whether the index values are unique Values:
  • Columns
  • DBNames
  • Tables
  • Foreignkeys
  • Index
  • Procedures
  • Version

datasource

Datasource to use to connect to the database.

name
Required

Name to use to refer to the result.

dbname

Name of the database.

username

User name to connect to the database.

password

Password to connect to the database.

pattern

Used only if type = "tables" ,type = "columns" , or type = "procedures"
. Specifies a filter to retrieve information about specific tables, columns, or stored procedures. Use an underline (_) to represent a single wildcard character and a percent sign (%) to represent a wildcard of zero or more characters.

table

Name of the table from which you retrieve information.

Fork me on GitHub