SQL in a Nutshell, 2nd Edition

Sybase Adaptive Server SQL Statements

As we saw in the previous section, there is significant overlap in the type support offered by Sybase and SQL Server. This section compares the SQL dialects of Sybase to SQL Server. In most cases, the SQL Server statements described in Chapter 3 apply to Sybase as well. This section outlines those statements that are different between the two platforms.

In Table A-2, the SQL commands are listed along with notes containing the differences between SQL Server and Sybase. While most of the statements have identical syntax and meaning, for those statements that contain large differences, the syntax for Sybase is listed with notes on how the statements differ.

Table A-2. Sybase Adaptive Server SQL statements

Command	Notes
ALTER PROCEDURE	Sybase does not support the ENCRYPTION keyword or replication through the FOR REPLICATION keywords.
ALTER TABLE	Sybase does not support the ROWGUIDCOL keyword or the CHECK and NOCHECK keywords for enabling constraints. ALTER TABLE table_name [ADD {column_name datatype attributes}[,...]] | [DROP column_name[,...]] | [ADD CONSTRAINT {constraint_name constraint_clause}[,...]] | [DROP CONSTRAINT constraint_name[,...]] | [MODIFY {column_name data_type [[NOT] NULL]}[,...]] | [{ENABLE|DISABLE} trigger_name]
ALTER TRIGGER	Sybase has no equivalent to the ALTER TRIGGER statement in SQL Server. For equivalent functionality, drop the existing trigger with a DROP TRIGGER statement and recreate it with the CREATE