Basic Important commands in Sybase

 How to list available instances in server

login to the os level and enter showserver command

NOTE : We can install multiple instances on server.

How to login Sybase instance

$ isql -S server_name -U user_name -X -w400

Password:

How to change your password

1> sp_password old_password,new_password

2> GO

How to check long running transactions

1>select *from syslogshold

2>go

How to list available databases

1> sp_helpdb

2> go

1> SELECT name FROM master..sysdatabases

2> GO

How to check all connections

1> sp_who

2> go

How to select a database

1> USE <DB NAME>

2> GO

How to list user tables in the database

1> SELECT name FROM sysobjects WHERE type='U'

2> GO

How to list views in the database

1> SELECT name FROM sysobjects WHERE type='V'

2> GO

How to list stored procedures in the database

1> SELECT name FROM sysobjects WHERE type='P'

2> GO

How to list all tables/views/procedures in the database

1> sp_help

2> GO

How to list the column names of a table with data type 

1> sp_help table_name

2> GO

How to display a stored procedure

1> sp_helptext <stored_procedure_name>

2> GO

How to get out of the database

1> QUIT

or

1> EXIT