Install Online Help for Transact-SQL Syntax

The %SYBASE%\%SYBASE_ASE%\scripts directory contains scripts for installing the syntax help database, sybsyntax.

You can install any of these scripts, depending on the need for SAP ASE information on your server. The first script you execute creates the sybsyntax database and the needed tables and indexes. Any scripts that you execute after the first one add to the existing information in the database. If you reexecute a script, any previously installed rows of information are deleted from the table in the database and then reinstalled.

You can retrieve this data using sp_syntax. For more information on sp_syntax, see the Reference Manual: Procedures.

All SAP ASE installations include the inssynsq script, which includes syntax information for Transact-SQL, the system procedures, and SAP ASE utilities. Executing this script installs the SQL portion of the sybsyntax database.