Sybase system databases
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / dilip voora
By default master, model, sybsystemdb, sybsystemprocs and tempdb will be installed after installing ASE on your machine.
sybmgmtdb is an optional database which is using for scheduling task, jobs etc.
Is This Answer Correct ? | 1 Yes | 0 No |
What will cause the size of a stored procedure to grow in sybase?
What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?
What are triggers? Why do we use them? Diff types of triggers? What are magic tables?
What is a natural key in sybase?
How do I configure identities in sybase?
Differences between clustered and non-clustered in sybase?
Explain coalesce.
How do I remove duplicate rows from a table in sybase?
can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com
Explain asa, asa ultralite.
How does sybase replication work?
Is sybase sql?