ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace: • changeTableSql • autoExecute • adodb_gmdate • getMenu • Logging • getCommentSql
v5:dictionary:getcommentsql

This is an old revision of the document!

getCommentSql

Syntax
string getCommentSql(
  string $tableName,
  string $columnName
  )

Description

The method getCommentSql() returns a string containing the SQL necessary to read the column comments from a table, if the database supports it.

Usage

/*
* On an Oracle Database
*/
$dict = newDataDictionary($db);
$s = $dict->getColumnSql('mytable','mycolumn');
print $s;
/*
* Prints: select comments from USER_COL_COMMENTS where TABLE_NAME='mytable' and COLUMN_NAME='mycolumn'
*/

Notes

  • Support for this method is limited
  • Special rights may be required to execute the returned SQL
  • If not supported, the method returns false
v5/dictionary/getcommentsql.1452647170.txt.gz · Last modified: 2017/04/21 11:28 (external edit)