ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-66
NonStop ODBC Server Compared With SQL Server
DROP DATABASE is equivalent to USERCAT DEINSTALL with the CASCADE
parameter (described under USERCAT DEINSTALL Statement on page 7-24).
Table 4-17 summarizes the objects, mapping tables, and catalogs that are dropped by
DROP DATABASE.
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, DROP DATABASE 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 CATALOG.
The NonStop SQL/MP catalog is dropped only if all objects registered in it were
created through the NonStop ODBC Server. See How the NonStop ODBC Server
Drops Database Objects on page 4-65.
Table 4-17. Dropping Mapping Tables, Objects, and Catalogs
Which Items Are Dropped
If the Database Contains
NonStop ODBC Server Mapping Tables Objects Created Using the NonStop ODBC Server NonStop SQL/MP Catalog Objects Created Using NonStop SQL/MP and Refreshed for the NonStop ODBC Server
Only objects created using the NonStop ODBC
Server
xxx–
Objects created using the NonStop ODBC
Server and objects created using NonStop
SQL/MP
xx––
x Indicates the item is dropped
– Indicates the item is not dropped
Feature In SQL Server
In Programs Used With the NonStop
ODBC Server
Can DROP DATABASE
be inside a user-defined
transaction?
No Yes
See DDL Statements Allowed in User-
Defined Transactions on page 4-3.