Contents

cfdbinfo

Description

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.

Category

Other

Implemented

Usage Syntax

<cfdbinfo  
	datasource="String"
	name="String"
	type="String"
	[procedure="String"]
	[dbname="String"]
	[password="String"]
	[pattern="String"]
	[table="String"]
	[username="String"]
 />

[] = Optional attribute

Attributes

Name Type Required Default Description
datasource String Yes Datasource to use to connect to the database.
name String Yes Name to use to refer to the result.
type String Yes Type of information to get
procedure String No Name of the procedure from which you retrieve information.
dbname String No Name of the database
password String No Password to connect to the database.
pattern String No Specifies a filter to retrieve information about specific tables, columns, or stored procedures
table String No Name of the table from which you retrieve information.
username String No User name to connect to the database.

Example Usage