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