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. | |