Database Technologies‎ > ‎Sybase‎ > ‎

System Databases

 
System Database, there are few databases which are required for
running of the sybase instance.
 
We have
 
Master
Model
Sybsystemprocs
sybsystemdb
tempdb
 
In addition to above we could have
sybsyntax
dbccdb
sybsecurity
 

 Master

 The main part of the Sybase instance

 Model

 Template for creating new databases

 Sybsystemprocs

 System supplied stored procedures

 sybsystempdb

 Distributed transaction management    

 tempdb

Group by, Order by, etc Sorting operations

 sybsyntax (optional)

 Syntax , help on sql statements

 dbccdb (optional)

Consistency checking

 sybsecurity (optional)

If Auditing is required.

Comments