Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Switching to a different Sybase database

Tech Computer Center logo

When you start sqsh, the database the TCC first created for you is opened for you. If you have another database, you may want to work in it instead.

At the end of each command press the space-bar or press enter before continuing the next step.

  1. To use a different database, type
            use
  2. Type the name of the database to change to.
  3. Type
            go
  4. Press Enter.

If everything works okay, you see your database prompt change to the new database name, and the counter will reset to 1.

For example, if you change to a database called pubs2 by typing

        use pubs2 go
and pressing enter you see
        .pubs2.1>

If you see something like

        Msg 911, Level 11, State 2
        Server '', Line 1
        Attempt to locate entry in sysdatabases for
        database 'pubs' by name failed - no entry found
        under that name. Make sure that name is entered
        properly.
then you typed a database name that is not valid. Try it again with the right name.
Next: Deleting a Sybase database
See also: Using multiple databases in Sybase
Previous: Creating an additional Sybase database
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Information Technology and Communications: Help System
ITC Publications
To report a problem: File a ticket
Send mail to the User consultant on duty or call them at 575-835-5437
Home: About New Mexico Tech

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson
Last updated: 1997/06/25 00:43:49 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/db_switch.html
QR two-dimensional bar code