By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

show comments for columns ...

P: n/a
Hello,

I need help generating a sql statement for showing columns and comments
of a table.

Something like:

db2 select columname,comment from dontknow where tablename='table'

Thanks for your support

Dirk
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Dirk Deimeke wrote:
Hello,

I need help generating a sql statement for showing columns and comments
of a table.

Something like:

db2 select columname,comment from dontknow where tablename='table'

Thanks for your support

Dirk

select colname, remarks from syscat.columns where tabname='XXXX'

--
Anton Versteeg
IBM Netherlands
Nov 12 '05 #2

P: n/a
Dirk Deimeke wrote:
Hello,

I need help generating a sql statement for showing columns and comments
of a table.

Something like:

db2 select columname,comment from dontknow where tablename='table'

SYSCAT.COLUMNS.REMARKS

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

P: n/a
Anton Versteeg <An************@nnll.ibm.com> schrieb:
select colname, remarks from syscat.columns where tabname='XXXX'
That is too easy ...

Thank you!

Dirk

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.