SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Database tables

  1. #1
    SitePoint Addict rabbitsfeat's Avatar
    Join Date
    Nov 2006
    Posts
    334
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database tables

    For some reason unknown to me when I created a database and then the tables for it, these tables have appeared in my other databases—including the master database... I'm using SQL Server 2005 Express.

    I've deleted these tables from those databases.

    Will this remove them and restore the master (and other) databases to what they were? I've heard you're not supposed to tamper with the master database.

    Or will I have to reinstall SQL Server 2005 Express?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    before you create a database, you're actually in another database

    so, right after you create a new database, issue the USE command for it, and then you can continue and create the tables

    i've created tables in master by mistake too, just go ahead and drop them
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •