exec sp_tables? What about creation date?

Last Post 17 Dec 2010 07:52 AM by gunneyk. 5 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dstoltz
New Member
New Member

--
17 Dec 2010 05: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 05: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 05:59 AM
awesome! thank you!
presz
New Member
New Member

--
17 Dec 2010 06: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 07: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 07: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.


Acceptable Use Policy
---