ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-73
NonStop ODBC Server Compared With
NonStop SQL/MP
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is DROP VIEW.
When used through the NonStop ODBC Server, DROP VIEW differs from the NonStop
SQL/MP implementation in the following way:
Are dependent views and indexes
dropped?
No Yes, but the mapping entries
for the dependent objects are
not dropped. See Dropping
Dependent Views and Indexes
on page 4-69.
Format of an owner name SQL Server identifier A Guardian logon name.
For information on specifying
owner names, see Language
Elements on page 4-5.
Security requirements imposed SQL Server security
requirements
NonStop SQL/MP security
requirements; anyone with the
proper file-system security can
drop a view.
For information, see the
description of the DROP VIEW
statement in the NonStop
SQL/MP Reference Manual.
Feature In NonStop SQL/MP
In Programs Used With the
NonStop ODBC Server
Number of views you can
drop with a DROP VIEW
statement
One Multiple
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server