ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-68
NonStop ODBC Server Compared With SQL Server
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, DROP INDEX differs from the SQL
Server implementation in the following ways:
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is DROP INDEX.
When used through the NonStop ODBC Server, DROP INDEX differs from the
NonStop SQL/MP implementation in the following ways:
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server
Can DROP INDEX be inside
a transaction?
No Yes
See DDL Statements Allowed in
User-Defined Transactions on
page 4-3.
Which objects must be
accessible?
N.A. These associated objects:
•
The underlying table
•
All object program files using the
underlying table (if any)
•
Catalogs containing the
description of the index
Should partitions be
available?
N.A. SQL Server
does not have
partitioned indexes.
Yes, if the index is a partitioned
index.
Security restrictions SQL Server security
restrictions apply.
NonStop SQL/MP security
restrictions apply for the NonStop
SQL/MP process accessor ID and for
catalogs that describe indexes
affected by the drop.
Feature In NonStop SQL/MP
In Programs Used With the
NonStop ODBC Server
Number of indexes you can drop
with the DROP INDEX statement
One Multiple
How you qualify the index name Specify the Guardian
file name that
identifies the index.
Specify the table name that
the index is associated with,
followed by the index name.