Database

Sybase

• Show all databases

sp_helpdb

• Show a single database

sp_helpdb N'<db_name>'

• Get all tables

sp_tables '%'

• Filter by database

sp_tables '%', '%', 'master', "'TABLE'"

• Get all Sybase procedures

sp_stored_procedures '%'

• Filter by owner and db

sp_stored_procedures '%', 'dbo', 'master'