How to drop database table created by specific user

Question

There is need to setup a maintenance job to drop database tables created by particular user list in SQL SERVER.

I was trying to use Sys.Objects, Sys.tables and sysusers objects but not able to build exact TSQL For this.

Please provide solution.

Answer 1

created by particular user list in SQL SERVER.

SQL Server don't log how created which object in a database.
To achieve this you have to log it on your own, e.g. using a DDL trigger.
See
https://learn.microsoft.com/en-us/sql/relational-databases/triggers/ddl-triggers?view=sql-server-ver15

Answer 2

Hey,
Below query would help you get that list :
select
so.name, su.name, so.crdate
from
sysobjects so
join
sysusers su on so.uid = su.uid

and then you can use dynamic sql to drop those