Identifying Table Creator

UDA

Identifying Table Creator

The description already summarizes it...

How do I write SQL to identify all tables created by user XYZ so I can drop only these tables?

Thanks,
gecko
2 REPLIES

Re: Identifying Table Creator

look for creatorname in dbc.tables view

Re: Identifying Table Creator

You may execute the fillowing query for your result:

SELECT CREATORNAME FROM DBC.TABLES WHERE TABLENAME = 'TABLE_NAME';