Can't See Existing Tables in SQL server 2005 express??!

Posted on 2009-04-17
Last Modified: 2012-06-22
OK, this is weird.

I have refreshed, restarted MS SQL Server Management Studio Express, but still, I cannot see the tables which it claims already exist.

Even from MS C# 2005, I cannot see any tables.

I can drop the tables, and I can re-create them, both at will, but I can't see them...

I include an image as proof...
Question by:yaronusa
    LVL 15

    Accepted Solution

    Check the database connection.. you might be creating and dropping it under master, model. msdb or temp databases.
    LVL 6

    Assisted Solution

    agree with faiga16; most of the time the drop down box says 'master'. Also different with previous versions is that the tree on the left needs a refresh after a create statement.

    Author Comment

    ok, you both are right, the tables ended up going into 'master'... thank 4 helping a n00b

    Author Closing Comment

    thanks all!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    729 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

    24 Experts available now in Live!

    Get 1:1 Help Now