SysObject View

Posted on 2007-10-10
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

    SELECT * FROM sys.objects
    SELECT * FROM sys.columns

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now