Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Unanswered: Newb Question: Edit master tables?

    Hi,

    I am a newb to Sybase, and have been toying around with a test system (12.5). I've found that I can create and delete tables in the "master" database, using both the PC Client and isql. However, for some reason, I cannot modify or delete columns. When I try, I get the following message:-

    "The 'select into' database option is not enabled for database 'master'. ALTER TABLE with data copy cannot be done. Set the 'select into' database option and re-run."

    When attempting to alter the 'select into' option, I've found that:-

    "The 'master' database's options can not be changed."

    I've been poking around the 'net but haven't found anything helpful. Can anybody tell me if there is a way around this, or do I have to delete and re-create the entire table?

    Cheers,
    Steve.

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    First of all - do NOT create your own tables in the master database. Instead, create a new database and create tables, etc. in this new database.

    The master database should be reserved for system tables.

    Michael

Posting Permissions

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