Bug #53855 for DBIx-Class-Schema-Loader: need POD table and column comments for more backends

Wed Jan 20 14:50:17 2010 rmb32 [...] cornell.edu - Ticket created

Subject:

need POD table and column comments for more backends

Need implementations of _table_comment and _column_comment for more backends (oracle, db2, mssql...) With extra tests covering them of course.

Sat Oct 30 00:22:24 2010 justin.d.hunter [...] gmail.com - Correspondence added

Oracle support added: http://git.shadowcat.co.uk/gitweb/gitweb.cgi? p=dbsrgits/DBIx-Class-Schema- Loader.git;a=commitdiff;h=4cd5155bb0df2e2e59378d9e878af90285967e12 On Wed Jan 20 14:50:17 2010, rbuels wrote: Show quoted text

> Need implementations of _table_comment and _column_comment for more > backends (oracle, db2, mssql...) > > With extra tests covering them of course. >

Sat Oct 30 00:22:26 2010 The RT System itself - Status changed from 'new' to 'open'

Sun Sep 09 12:26:32 2012 rkitover [...] cpan.org - Correspondence added

An update on this ticket: SineSwiper added support for the REMARKS field from $dbh->table_info and $dbh- Show quoted text

>column_info in _table_comment and _column_comment in ::DBI.

Someone else (I forget who) added better support for MySQL, even though MySQL's support for comments is very lacking. There is also a generic mechanism available to store your comments in tables, a table_comments and column_comments tables (overridable via table_comments_table and column_comments_table attributes.) What is left is to investigate and test comment support for other supported DBs.

Thu Jun 22 10:44:47 2017 daxim [...] cpan.org - Correspondence added

for MSSQL: select t.name [Table], prop.value [TableComment] from sys.tables t left join sys.extended_properties prop on t.object_id = prop.major_id and prop.minor_id = 0 and prop.name = 'MS_Description' select t.name [Table], c.name [Column], prop.value [ColumnComment] from sys.tables t inner join sys.columns c on t.object_id = c.object_id left join sys.extended_properties prop on t.object_id = prop.major_id and c.column_id = prop.minor_id and prop.name = 'MS_Description'