v5:dictionary:comments
This is an old revision of the document!
Adding Comments To Tables
Database support for adding comments varies from full support (IBM DB2, PostgreSQL) to none (SQLite) with differing implementation methods. Databases that support it do it via 1 of 2 methods, Either be adding the comment as part of the table creation and modification process, or by adding a comment to a previously created table. In addition, databases have varying levels of support for adding comments to tables, columns and indexes. The following matrix shows available methods across supported databases.
| db2 | mssqlnative | mysql | oci8 | postgres9 | sqlite3 | |
|---|---|---|---|---|---|---|
| Table On Creation | YES | |||||
| Column On Creation | YES | |||||
| Index On Creation | YES | |||||
| Table After Creation | YES | YES | YES | YES | ||
| Column After Creation | YES | YES | YES | YES | ||
| Index After Creation | YES | YES | YES |
v5/dictionary/comments.1774210292.txt.gz · Last modified: by mnewnham
