Database Technologies‎ > ‎Sybase‎ > ‎

Sybase information



To see the database sever version;

1>select @@version
2>go



To see the current user

1>sp_displaylogin
2>go


To check role of current user
1> select show_role()
2> go

To  get information on objects,user,group and roles
1>sp_helprotect
2>go

To get information on all active roles
1>sp_activeroles
2>go


To get information on all roles granted to another role or user.
1>sp_displayroles
2> go

To get the information about all the database running on the instance

1>sp_helpdb
2>go


To get detailed information about a particular database
1>sp_helpdb <database_name>
2>go


To get the information about all the devices

1>sp_helpdevice
2>go

To get detailed information about a particular device
1>sp_helpdevice <device_name>
2>go




To get detailed information about an object

1>sp_help <object_name>
2>go


To get information about various server configured with the current dataserver instance

1>sp_helpserver
2>go




To get all the Initialization Parameters.

To Check the current configuration values the server uses and dump to a file

1>sp_configure "configuration file", 0, "write", "server.conf"
2>go



Comments