************************** SYBASE COMMANDS *********sybase***********

sp_spaceused - Indicates how much spaced is being used in the database

sp_spacereport - Indicates how much spaced is being used space used by tables

sp_help - Displays the definition of a table

sp_helpuser - Indicates who are all the database users? sp_helprotect - Displays db table permissions

sp_helpdb - Lists all the databases on the current se0er

sp_target - Lists all processes currently executing work against the DB

sp_tables - Lists all the tables in a database

sp_helpsegment 'default' - Lists the available memory in the server

sp_stored_procedures -- list stored procedues

http://msdn.microsoft.com/en-us/library/ms177500(v=sql.105).aspx

set queryplan on set noexec on if its using index or table scan

check these links :

http://sybase-architect.blogspot.in/2011/07/sybase-ase-how-to-see-all-column-names.html

http://users.telenet.be/pecop/sqlr/sqlbasics.html

http://www.softwarejobpost.com/basic-unix-interview-questions-with-answers-download-pdf/523/

http://www.dwbiconcepts.com/tutorial/24-interview-questions/50-top-25-unix-interview-questions-with-answers-part-i.html

http://www.gointerviews.com/top-50-unix-interview-questions/

http://vanibala.150m.com/pdf_files/unixiq.pdf