Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Simple SQL question

Options
  • 10-04-2006 4:15pm
    #1
    hannable80
    Registered Users Posts: 272 ✭✭


    when i log in to my sql in college i seem to be put in a created database called scott, i need to get out of this as every time i try to create a table , i get an error......Example of the data base
    DESC SCOTT.BONUS;
    DESC SCOTT.DEPT;
    DESC SCOTT.EMP;
    DESC SCOTT.SALGRADE;
    Can i get out of this Scott cheers


Comments

  • Options
    #2
    Karoma
    Registered Users Posts: 19,396 ✭✭✭✭Karoma


    It's intentional... What error?


  • Options
    #3
    JackieChan
    Closed Accounts Posts: 1,829 ✭✭✭JackieChan


    If you are logging on as SCOTT and are attempting to create the tables it is probably because they already exist.
    If you don't want to be logged in as scott then you must get another logon from your instructor.
    You can not do much without been connected to the database as a valid user


Advertisement