v5:dictionary:setcommentsql
This is an old revision of the document!
setCommentSql
Syntax
string setCommentSql( string $tableName, string $columnName, string $comment )
Description
The method setCommentSql()
returns a string containing the SQL necessary to set the column comments on a table to the specified value, if the database supports it.
Usage
/* * On an Oracle Database */ $dict = newDataDictionary($db); $s = $dict->setColumnSql('mytable','mycolumn','This is a comment'); print $s; /* * Prints: COMMENT ON COLUMN mytable.mycolumn IS 'This is a comment'; */
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/setcommentsql.1452647176.txt.gz · Last modified: 2017/04/21 11:27 (external edit)