exec sp_tables? What about creation date?

Last Post 17 Dec 2010 08:52 AM by gunneyk. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dstoltz
New Member
New Member

--
17 Dec 2010 06:25 AM
Is there any SP that will show ALL the tables creation dates?

Back in SQL 2000, it was easy to see all the creation dates in Enterprise Manager by clicking on the database - which would list all the tables, along with the creation dates.

In 2008, you can right click each table to find the creation date, but I'm looking to view them all at once...

Any ideas?

Thanks!
russellb
New Member
New Member

--
17 Dec 2010 06:48 AM
SELECT name [table], schema_name(schema_id) [schema], object_id, create_date FROM sys.tables
dstoltz
New Member
New Member

--
17 Dec 2010 06:59 AM
awesome! thank you!
presz
New Member
New Member

--
17 Dec 2010 07:08 AM
Also in Management Studio, you can choose which properties to display in Object Explorer Details window. Just right click column headings in Object Explorer Details window, and select the columns you want to see. Date Created is available.
dstoltz
New Member
New Member

--
17 Dec 2010 08:49 AM
That's an awesome tip - but if I hit F7 to open the Object Explorer Details windows, I'm not sure what I'm supposed to right click on....?

The only columns available are name, and policy health state.....

gunneyk
New Member
New Member

--
17 Dec 2010 08:52 AM
You need to have the table or stored procedure etc. node of the Tree highlighted in the Object Explorer to see all the relevant columns for all the objects in that class. You wont see it at the individual object level.
You are not authorized to post a reply.

Acceptable Use Policy