Concept Framework 1.0 documentation Contents | Index

ADOConnection.ListTables

Name Type Access Version Deprecated
ListTables function public version 1.0 no

Prototype:
array ListTables(string database="%")

Parameters:
database      the target database name (optional)

Description:
List the tables in a database. The connection must be opened.

Example: 
pragma warnings off



include DataBases.con



class Main {

	function Main() {

		var Connection=new ADOConnection();

		var DataSet=new ADODataSet(Connection);



		Connection.Open("Driver={SQL Server};Server=(local);Database=iadc;Uid=iadc;Pwd=iadc;");

		echo Connection.ListTables();



		echo Connection.ListColumns("sysobjects");



		Connection.Close();

		echo Connection.LastError();

	}

}

Returns:
Returns an array of arrays containing table descriptions. In case it failes, it returns null.

Documented by Eduard Suica, generation time: Thu Oct 15 20:01:57 2009 GMT(c)2009 RadGs Software