Previous Topic Next topic Print topic


X056: Table/View name already exists.

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:

SELECT name, ''table'' FROM sysibm.systables UNION SELECT name, ''view '' FROM sysibm.sysviews
Previous Topic Next topic Print topic