O'Reilly logo

SQL in a Nutshell by Kevin Kline

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required