The ODBC SQL Server driver fully supports the core SQL grammar. The SQL Server driver also supports almost all SQL statements in the extended ODBC grammar. When connected to SQL Server 6.5, the only extended ODBC grammar not supported is the DROP COLUMN clause of the ALTER TABLE statement, and the CASCADE and RESTRICT clauses of the DROP VIEW, DROP TABLE, and REVOKE statements. In accordance with the design of ODBC, the SQL Server driver will pass native SQL grammar to SQL Server.
This chapter provides information regarding supported and non-supported grammar. It includes the following sections: