|
System Tables
System tables
are
tables,
which are created when installing
ASE
or creating a new
database.
System tables contain data required to administer the server, a database or its
objects
Starting with ASE version 15.0.2, most of the system tables are
row level locked.
Prior to ASE version 15.0.2 system tables were exclusivly locked.
Where are system tables stored?
System tables are located in the databases
master,
sybsystemdb,
and
sybsecurity
as well as in all other databases. System tables are prefixed with sys. For example
sysdatabases,
sysservers
or
sysdevices.
System tables usually cannot be updated, unless the configuration parameter
"allow updates to system tables"
has been switched to "1". Caveat: Only manipulate system tables if you are fully aware of the consequences!
Sybase provided
System Stored Procedures
usually suffice to administer ASE and to generate updates to system tables.
|
