The following SELECT statement displays information about tables, views, and macros in the Personnel database, assuming that text for the database object is more than 12500 characters.
SELECT TableName,TableKind, LineNo, RequestText( char(50)) FROM DBC.TableTextV WHERE DatabaseName = 'Personnel' ORDER BY TableName, LineNo;