Answer Posted / prabhu
When you install Adaptive Server, it contains these system
databases:
The master database controls the user databases and the
operation of Adaptive Server as a whole. It stores
information about all user databases and their associated
database devices.
The model database is used by Adaptive Server as a template
for creating new user databases.
A new database cannot be smaller than the model
database.
? The sybsystemprocs database contains the system stored
procedures.
The sybsystemdb database contains information about
distributed transactions.
? The temporary database, tempdb, stores temporary objects,
including temporary tables created with the name
prefix ?tempdb..?.
? The sybsecurity database, contains the audit system for
Adaptive Server. It consists of:
The system tables, sysaudits_01, sysaudits_02, ...
sysaudits_08, which contain the audit trail
The sysauditoptions table, which contains rows describing
the global audit options.
All other default system tables that are derived from model
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How do I connect to sybase?
How to check if sybase database is up and running?
What are table partitions? How is it different with ase 15.0 version?
How do you check database space? What measures are there to increase the db space?
How do I make isql secure in sybase?
How would you configure identities in sybase?
What do you mean by sybase iq?
Why am I running out of locks on the replicate side in sybase ?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
Is sybase owned by sap?
What is open client in sybase?
How can I improve throughput in sybase?
There is no space in file system and you need to take a back up. What will you do?
How to connect to sybase database from linux?
what is update statistics in sybase?