sa_db_properties system procedure

Function

Reports database property information.

Syntax

sa_db_properties ( [ database-id ] )

Permissions

None.

Description

Returns the database ID number and the Number, PropNum, PropName, PropDescription, and Value, for each property returned by the sa_db_info system procedure.

Example

sa_db_properties

0,125,'Name','Database name','asiqdemo'
0,126,'Alias','Mounted database name','asiqdemo'
0,127,'File','Database file',
'/sys1/users/janed/sybase/ASIQ-12_7/demo/asiqdemo.db'
0,128,'PageSize','Database page size','4096'
0,129,'LogName','Database log file name',
'/sys1/users/janed/sybase/ASIQ-12_7/demo/asiqdemo.log'0,131,'ConnCount','Number of connections','1'
0,146,'FileVersion',
'Database file version number','1005'
0,147,'CheckpointUrgency',
'Database checkpoint urgency','30'
0,148,'RecoveryUrgency',
'Database recovery urgency','0'
0,151,'IQStore','IQ store is on/off','ON'
0,163,'CharSet','Character Set','iso_1'
0,164,'MultiByteCharSet',
'Multi Byte Character Set ( on/off )','OFF'
0,165,'Language','Language','unknown'