Monday, May 5, 2014
How to query Table - Column comments in Sybase IQ
Table and cloumn comments can be queried from sys.systables and sys.syscolumns system views in Sybase IQ. Comments are stored in remarks column.
SELECT remarks ,* FROM SYS.SYSCOLUMNS
Moreover, although names are very similar systable and syscolumn views do not have this information.
0 comments:
Post a Comment