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.
This tag supports only JDBC drivers, and does not support ODBC-based drivers, including the Microsoft Access driver.
cannot have a body.
This tag is also supported within
Datasource to use to connect to the database.
Name to use to refer to the result.
Type of information to get:
dbnames: database name and type
tables: information to all tables
columns: column information to a single table/view
version: version information of the database
procedures: information to all procedures
procedure_columns: column information to a single procedure
foreignkeys: information to all foreignkeys
index: information to all indexes
Name of the procedure from which you retrieve information.
Name of the database
Password to connect to the database.
Specifies a filter to retrieve information about specific tables, columns, or stored procedures
Name of the table from which you retrieve information.
User name to connect to the database.
Filter for type="tables" with a wildcard, defaults to all types when empty.
Note: Each Database implementation has it's own supported types
Introduced: Lucee 126.96.36.199 Examples
<cfdbinfo type = "columns" name = "db_info" datasource = "lucee" dbname = "tester" table = "test" >