This example shows a statement that selects any available commentary about columns in the Employee table:
SELECT ColumnName,CommentString FROM DBC.ColumnsV WHERE DatabaseName=’Personnel’ AND TableName=’Employee’ ORDER BY Columnid;
Result:
ColumnName CommentString ----------- --------------------------------------- EmpNo Employee serial number. Name Employee name, last then first initial. DeptNo JobTitle Salary YrsExp