All tables and views in a database must have unique names. To obtain a list of the tables or views in a database, you can perform the query:
Restriction: This topic applies to Windows environments only.
SELECT name, ''table'' FROM sysibm.systables UNION SELECT name, ''view '' FROM sysibm.sysviews
