The following SELECT statement displays information about tables, views, and macros in the Personnel database:
SELECT TableName,CreatorName,TableKind,ProtectionType FROM DBC.TablesV WHERE DatabaseName = ’Personnel’ ;
The query returns the following result:
TableName CreatorName TableKind ProtectionType ------------ ----------- --------- -------------- NewEmp GREENE M F EmployeeInfo GREENE V F Employee DBC T F Department DBC T F Project JONES T F Charges JONES T F