ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-71
NonStop ODBC Server Compared With
NonStop SQL/MP
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is DROP TABLE.
When used through the NonStop ODBC Server, DROP TABLE differs from the
NonStop SQL/MP implementation in the following way:
DROP VIEW
Use DROP VIEW to remove views from the database.
The DROP VIEW statement has the following syntax:
view-name
identifies the view to drop; view-name can be qualified with the owner name.
Are constraints
automatically dropped?
SQL Server does not have
constraints, but any rules
on the table lose their
binding, and any triggers
associated with the table
are automatically dropped.
Yes
Are dependent views and
indexes automatically
dropped?
No Yes, but the mapping entries for
the dependent objects are not
dropped. See Dropping
Dependent Views and Indexes on
page 4-69.
Security requirements
imposed
SQL Server security
requirements
NonStop SQL/MP security
requirements.
See the information on DROP
TABLE in the NonStop SQL/MP
Reference Manual.
Feature In NonStop SQL/MP
In Programs Used With the
NonStop ODBC Server
Number of tables you can drop
with a DROP TABLE statement
One Multiple
DROP VIEW [ owner.]view-name
[ , [ owner.]view-name ] ...
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server