Learn how to a build a cloud-first strategyRegister Now


SysObject View

Posted on 2007-10-10
Medium Priority
Last Modified: 2008-01-09
I would like to do in MS Sql 2005 server Management Studio the same thing I would do in Sql 2000 Enterprise Manager. In Sql 2000 Enterprise Manager, I would open the SysObjects table for the database. I could look at all the data and all the columns to determine Table names and ID. I could then look at SysColumns to get column names.
I can't find SysObect information in SQL 2005. I see it as a System View in the Master database, but I cannot find a way to see the actual columns and data.
How can I browse Table names and Columns names, etc in SQL 2005 Server Management Studio?
Question by:mpdillon
1 Comment
LVL 75

Accepted Solution

Aneesh Retnakaran earned 2000 total points
ID: 20050126
SELECT * FROM sys.objects
SELECT * FROM sys.columns

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Loops Section Overview

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question