Sybase isql Common commands

1Isql-usa-s Service Name--General Login2Isql-usa-s Service Name-jcp936--SA user logs on client using character set cp9363 4C:\USERS\ADMINISTRATOR>ISQL-USA-SRUSKYPC--gracefully shut down the database5 Password:6  　　 1>shutdown7  　　 2>Go8 9 shutdown with nowait go ———— close Sybase serviceTen Shutdown syb_backup Go (service name) ———— turn off Sybase services One  A sp_helpserver Go ———— view service name -  -sp_helpdb Go---View information for all databases the  -Use PUBS2 Go--using the PUBS2 database -Sp_help Go--View all tables in the current database -  +SP_HELP TableName go--Check table Structure -  +Sp_helpindex TableName Go--View Table Index A  atsp_helpdb Master go--View a database information, such as Master -  -Sp_helpdevice Go---View all device information -  -Sp_helpdevice devicename go--View a device information -  inSp_helpsort go--View the character set and sort order of the server -  toSp_displaylogin username go--View information for a user +  -sp_who go--View connected server process information or sp_who username go the  *Sp_lock go--Viewing lock information $ Panax Notoginseng Select@@ version Go ———— view Sybase versions -  the sp_version Go ———— View the Sybase version +  ASp_passwordNULL, Lonton go ———— set the password for the SA user (the initial ASE password is empty) the  + sp_helpdevice Go ————— View data device information for Sybase - SelectName,phyname,vdevno,low fromMaster.. sysdeviceswhereName=' master ' go $  $  - drop database testdb go ———— Delete databases -  theSp_dropdevice ' TestDB ' Go---Deleting a database device - Wuyi  the sp_helpsort Go ———— View the system's default sort, character set, and primary sort order table - SelectName,id fromsyscharsets Go ———— View the installation status of the system character set Wu  -sp_configure "default Char"Go ———— View the default character set currently in use About  $ startserver–f servername ———— start Sybase database service -  - sp_who Go ———— view logged in user status - sp_who user name Go A  + sp_helpuser Go ———— view database information the  - sp_dropuser username Go ———— Delete a database user $  theSp_locklogin Aifusenyu, 'Lock/unlock ' go ———— lock or unlock users the  the Sp_locklogin Go ———— View the list of currently locked users the  - Sp_displaylogin [LoginName] Go ———— View the list of logged in users in  the sp_addgroup grpname Go ———— Create a user group the  AboutSp_helpgroup/grouname Go ———— View user group information the  the sp_adduser Loginname[,name_in_db[,grpname]] Go ———— Create a database user the  + sp_changedbowner ' loginname ' Go ———— change the owner of the database.  -  the sp_changegroup groupname,name_in_db Go ———— Remove this group from the userBayi  the sp_dropgroup groupname go ———— Delete a user group the  - sp_dropuser username Go ———— Delete a database user -  the--Hate isql and a dog behind every command.

Sybase isql Common commands