Sybase - Commands, SQLs, etc

• Search Sybase objects by its type

SELECT name FROM sysobjects
WHERE type='D'

'U' -- user

'S' -- system

'P' -- procedure

'V' -- view

'D' -- default

'TR' -- trigger

• Show details of a stored-procedure

sp_helptext 'sp_how_are_you'

• Get DB name

SELECT db_name()

• to continue