Table analysis

Query (DQL) to find tables created recently:

select * from dm_dbo.dm_sysobjects where "type" = 'U' order by crdate desc