JuanBob
SSCertifiable
Points: 5059
More actions
July 21, 2006 at 2:02 pm
#173484
SQL 2000 on Win2003.
How would I drop a table with an unknown name that is older than 2 weeks old?
Thanks!
Daniel Cho
SSC Enthusiast
Points: 100
July 21, 2006 at 2:09 pm
#650864
SYSOBJECTS System table has a CrtDate (create date) column which should meet your needs. Be careful you only search for user tables.
July 21, 2006 at 2:22 pm
#650868
Got it, thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply