Railo 4.2 Reference
Choose a tag:

Tag <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. This tag supports only JDBC drivers, and does not support ODBC-based drivers, including the Microsoft Access driver.

Body

Dieses Tag darf keinen Body haben.

Beispiel

	<cfdbinfo
		[datasource="string"]
		[dbname="string"]
		name="string"
		[password="string"]
		[pattern="string"]
		[procedure="string"]
		[table="string"]
		type="string"
		[username="string"]>
	
Diese tag kann auch innerhalb von cfscript verwendet werden
	<cfscript>
		dbinfo
		[datasource="string"]
		[dbname="string"]
		name="string"
		[password="string"]
		[pattern="string"]
		[procedure="string"]
		[table="string"]
		type="string"
		[username="string"];
	</cfscript>

Attribute

Die Attribute für dieses Tag sind fest vorgegeben. Ausser den nachfolgend angegebenen Attributen dürfen keine weiteren verwendet werden.
Name Typ Required Beschreibung
datasource string No Datasource to use to connect to the database. 
dbname string No Name of the database 
name string Yes Name to use to refer to the result. 
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 
procedure string No Name of the procedure from which you retrieve information. 
table string No Name of the table from which you retrieve information. 
type string Yes 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

    ,tables,columns,version,procedures,foreignkeys,index,users 
  • username string No User name to connect to the database.