3-1-Tags:CFDBInfo

last edited by usericon

lmajano on 23-Aug-2009

cfdbinfo

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.

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.