ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-14
Statements
DROP INDEX x The following associated objects must be
accessible:
•
The underlying table
•
All object program files using the
underlying table (if any)
•
Catalogs containing the description of the
index
DROP
PROCEDURE
––
DROP RULE – Use the NonStop SQL/MP DROP
CONSTRAINT statement in pass-through
mode.
DROP TABLE x Dependent views are automatically dropped,
but you should drop them first because they
are not dropped from the mapping tables.
DROP TRIGGER – –
DROP VIEW x Dependent views are automatically dropped.
DUMP DATABASE – –
DUMP
TRANSACTION
––
EXECUTE x The WITH RECOMPILE clause is not
supported.
GOTO – –
GRANT Accepted, but not
performed
–
IF...ELSE – –
Table B-5. NonStop ODBC Server Support of Transact-SQL
Statements (page 4 of 7)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported