Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    12

    Unanswered: Understanding Sybase database tables

    I am trying to understand the SYBASE database tables "sysdatabases", "sysusages" and "sysdevices". My requirement is to know the information on the "databases" existing in the Sybase database.

    What does the columns "cntrltype" and "low","high" columns stand for in "sysdevices" table ?

    What is "vstart" in "sysusages" ?

    Is there an AUTOEXTEND feature (present in Oracle and SQLServer) to increment the size of a database automatically ? I found "ALTER DATABASE " but that is not dynamic if I am right.

    Any help is appreciated

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Check this out...

    http://sybooks.sybase.com/onlinebook.../162995;hf=0#X

    http://sybooks.sybase.com/onlinebook.../171457;hf=0#X

    for a dbid vstart is always between low & high.

    NO, as of now auto increment is not supported in Sybase. Although you can do the same using shell scripting or probably in Job Scheduler in version 12.5.

    HTH.

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Originally posted by mkalsi
    NO, as of now auto increment is not supported in Sybase. Although you can do the same using shell scripting or probably in Job Scheduler in version 12.5.

    HTH.
    AUTOEXTEND feature IS supported and available in Sybase ASE 12.5.1 onwards.

  4. #4
    Join Date
    Mar 2004
    Posts
    12
    Thanks for the help !

Posting Permissions

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