Database common commands

sybase

 

sp_help -lists all objects

 list all objects in a specific database including tables and views.

select name from sysobjects where type='U'

Refer to http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.tables/html/tables/tables46.htm for details of sysobjects

sp_helpdb

DB2

select * from syscat.tables where type='T'

 

describe table schema.table