Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kristen
Test
22859 Posts |
 Posted - 2010-02-14 : 16:10:08
|
| In SSMS how do I get a list of tables?I want to see tables ordered by Create Date - like I used to be able to do in SQL2000 Enterprise manager.Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-15 : 01:17:42
|
| SELECT * FROM sys.tables ORDER BY Create_Date; |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-15 : 02:15:32
|
| hahaha ... thanks Russell. So I can't just click on "Tables" and get a nice list displayed - and then click the Create Date column heading to get them sorted?Progress eh? ... |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-02-15 : 12:39:00
|
you get get that list in the GUI. you have to get the "object explorer details" tab open first though. It's under the "view" menu.
elsasoft.org |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-15 : 13:12:58
|
| Thanks Jesse - would never have thought of looking there in a million years. Sticking a hint on the Right-Click menu would have been helpful! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-16 : 01:32:16
|
that was a new tip for me. Thanks Jesse for sharing this info  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSMS SQL2008 Table List