ADOConnection.ListColumns

public function ListColumns

Prototype:

array ListColumns(string table="",string columns="")

Parameters

table

the table name

columns

the column name (optional)

Description:

List columns in a table.

Return value:

Returns an array of arrays describing the columns in the given table. If it fails, it returns null.

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();
	}
}