List of procedures
MODIFIED SYBASE PROCEDURES
sp__depends Better version of sp_depends
sp__help Better sp_help
sp__helpdb Database Information
sp__helpdevice Break down database devices into a nice report
sp__helpgroup List groups in database by access level
sp__helpindex Shows indexes by table
sp__helpsegment Segment Information
sp__helprotect Simple Protection Info for the database
sp__helptext Show comments with line splits ok
sp__helpuser Lists users in current database by group (includes aliases)
sp__lock Lock information
sp__syntax Works on any procedure to give you syntax
sp__who sp_who that fits on a page
SYSTEM ADMINISTRATOR PROCEDURES
sp__block Blocking processes.
sp__dbspace Summary of current database space information.
sp__dumpdevice Listing of Dump devices
sp__diskdevice Listing of Disk devices
sp__helpdbdev Show how Databases use Devices
sp__helplogin Show logins and remote logins to server
sp__helpmirror Shows mirror information, discover broken mirrors
sp__segment Segment Information
sp__server Server summary report (very useful)
sp__stat Give basic server performance information (loops)
sp__vdevno Who's who in the device world
DBA PROCEDURES
sp__badindex list badly formed indexes (allow nulls) or those needing statistics
sp__collist list all columns in database
sp__find_missing_index Finds keys that do not have associated index
sp__flowchart Makes a flowchart of procedure nesting
sp__groupprotect Permission info by group
sp__indexspace Space used by indexes in database
sp__id Gives information on who you are and which db you are in
sp__noindex list of tables without indexes.
sp__helpcolumn show columns for given table
sp__helpdefault list defaults (part of objectlist)
sp__helpobject list objects
sp__helpproc list procs (part of objectlist)
sp__helprule list rules (part of objectlist)
sp__helptable list tables (part of objectlist)
sp__helptrigger list triggers (part of objectlist)
sp__helpview list views (part of objectlist)
sp__objprotect Permission info by object
sp__read_write list tables by # procs that read, # that write, # that do both
sp__trigger Useful synopsis report of current database trigger schema
sp__whodo sp__who - filtered for only active processes
AUDIT PROCEDURES
sp__auditsecurity Security Audit On Server
sp__auditdb Audit Current Database For Potential Problems
sp__checkkey Generate script for referential integrity problems (uses key info from sp_foreignkey)
REVERSE ENGINEERING PROCEDURES
sp__revalias get alias generation script for current database
sp__revdb get database generation script for server
sp__revdevice get device generation script for server
sp__revgroup get group generation script for current database
sp__revindex get index generation script for current database
sp__revlogin get login generation script for server
sp__revmirror get mirror generation script for current database
sp__revsegment get segment generation script for current database
sp__revtable get table generation script for current database
sp__revuser get user generation script for current database
OTHER PROCEDURES
sp__bcp Create unix script to bcp in/out database
sp__date Who can remember all the date styles?
sp__iostat Loops n times showing active processes only
sp__grep Search for patern
sp__isactive Shows info about a single active process
sp__ls Lists specific objects
sp__quickstats Quick dump of server summary information
sp__whoactive Show info about who is active
分享到:
相关推荐
在sybase中实现分页技术的存储过程 procedures
Sybase IQ手册,关于建立空间、表、存储过程等方面的管理。
CHAPTER 1 File Locations and Installation Settings CHAPTER 2 Database Options CHAPTER 3 SQL Language Elements CHAPTER 4 SQL Data Types ...CHAPTER 10 System Procedures CHAPTER 11 System Views
It provides support for multiple types of relational databases, such as MySQL, Microsoft SQL Server, Sybase, Oracle, DB2, Apache Cassandra, Derby and Hive, Informix, MongoDB, PostgreSQL, SQLite and ...
Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgresSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE) ...
Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgresSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE) ...
Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgresSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE) ...
Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgresSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE) ...
Oracle, SQLServer, MySQL, Access, SQLAnywhere and Sybase. · Database design Build the database model by BDB, support forward-engineering and reverse-engineering, and the comparison update and double...
* Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers * A robust programming editor that embeds the powerful EditRocket code editor that supports 20 ...
4.1PostgreSQL 6.5 - 7.4Firebird 1.0 - 1.5Interbase 5.0 - 7.5Microsoft SQL Server 7, 2000Sybase ASE 12.0, 12.5Oracle 9iSQLite 2.8For other databases we propose to use implemented Active Data Objects ...
Ray Rankins, president of Gotham Consulting Services, has worked with Sybase and Microsoft SQL Server for more than 23 years and is coauthor of Sybase SQL Server Unleashed, Microsoft SQL Server 2000 ...
It supports these database: Oracle, MS SQLServer, Access, MySQL, SQLAnyWhere and Sybase. You can simplify the process of your software development through BDB. 1.The database design. Build the ...
It suppots such database as Oralce,MS SQLServer,MySQL,Access,SQLAnywhere and Sybase. Through the BDB you can quickly build up a database model and do two-way synchronization entities with the ...
It suppots such database as Oralce,MS SQLServer,MySQL,Access,SQLAnywhere and Sybase. Through the BDB you can quickly build up a database model and do two-way synchronization entities with the ...
It supports these database: Oracle, MS SQLServer, Access, MySQL, SQLAnyWhere and Sybase. You can simplify the process of your software development through BDB. 1.The database design. Build the ...
It supports these database: Oracle, MS SQLServer, Access, MySQL, SQLAnyWhere and Sybase. You can simplify the process of your software development through BDB. 1.The database design. Build the ...
It supports these database: Oracle, MS SQLServer, Access, MySQL, SQLAnyWhere and Sybase. You can simplify the process of your software development through BDB. 1.The database design. Build the ...
It supports these database: Oracle, MS SQLServer, Access, MySQL, SQLAnyWhere and Sybase. You can simplify the process of your software development through BDB. 1.The database design. Build the ...