How do I View Tables in SQL query analyzer window?

Question

Post reply

How do I View Tables in SQL query analyzer window?

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

Do you mean the object browser? Either press F8 or click on Tools, Object Browser, Show/hide.

Greg

Robert Davis One Orange Chip Points: 28027 More actions · Answer 2

I don't think they had object browser in SQL 7. It's been a while, so I could be wrong, but i think it was new in SQL 2000. If I'm right, there is no such option in Query Analyzer in SQL 7.

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

I think you're right, Robert. I don't have an 7.0 instance, so I can't see for sure.

Greg

Wendy K Old Hand Points: 311 More actions · Answer 4

Thanks all for your reponses....it must be a feature added in SQL 2000, because I don't have those options. I've used 2000 and 2005 and had the capability but couldn't find it here so it must be a post 7 upgrade.

Robert Davis One Orange Chip Points: 28027 More actions · Answer 5

In fact, if memeory serves me correctly, I think it was new in SQL 2000 SP1.

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]