How to find out who created a table?

_{Wednesday, November 7, 2007 12:54 AM}

How can I find out who created a table?

_{Wednesday, November 7, 2007 1:17 AM ✅Answered}

Unless you are already auditing the actions taken in your database, you cannot find this out later. System catalogs only record the current owner of an object, which may or may not be the object's creator.

Thanks

Laurentiu

_{Wednesday, November 7, 2007 1:45 AM ✅Answered}

Check the principal_id in sys.objects. It will not be always accurate. Even you can transfer the objects

select *from Sys.Objects

select *from sys.schemas

select *from sys.database_principals

or to get an accurae picture Use DDL Trigger...

http://madhuottapalam.blogspot.com/search?q=DDL+Trigger

Madhu

_{Wednesday, November 7, 2007 12:56 AM}

How to find out who created a table?

I tried select * from sys.objects where name = 'tablename', but there's no column for creator.

_{Wednesday, November 7, 2007 2:09 AM}

Please try not to duplicate the posts... Merging