cfdbinfo
8
3

Overview ColdFusion Open BlueDragon Lucee

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

Attributes

Name Required Type Default Description
8
3
datasource No String Datasource to use to connect to the database.
8
3
dbname No String Name of the database.
3
dbnames No Name of the database (alias for dbname)
8
3
name Yes String Name to use to refer to the result.
8
3
password No String Password to connect to the database.
8
3
pattern No String 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.
3
procedure No Name of the procedure from which you retrieve information.
8
3
table No String Name of the table from which you retrieve information.
8
3
type Yes String 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
8
3
username No String User name to connect to the database.