ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-41
Miscellaneous Transact-SQL Statements
CREATE INDEX Creates indexes. CREATE INDEX
CREATE TABLE Creates new tables. CREATE TABLE
CREATE VIEW Creates views. CREATE VIEW
DROP DATABASE Removes one or more catalogs. DROP CATALOG
DROP INDEX Removes an index. DROP INDEX
DROP TABLE Removes a table, along with all data,
indexes, dependent views, and permission
specifications for that table.
DROP TABLE
DROP VIEW Removes views. DROP VIEW
DELETE Removes rows from a table. DELETE
DML Statements
INSERT Adds new rows to a table or view. INSERT
SELECT Retrieves rows from tables. SELECT
TRUNCATE TABLE Removes all rows from a table without
logging deletions.
None
UPDATE Changes data in existing rows, either by
adding new data or modifying existing data.
UPDATE
Transaction Management Statements
BEGIN
TRANSACTION
Marks the starting point of a user-specified
transaction.
BEGIN WORK
COMMIT
TRANSACTION
Marks the ending point of a user-specified
transaction. All database changes since the
preceding BEGIN TRANSACTION statement
become permanent.
COMMIT WORK
ROLLBACK
TRANSACTION
Rolls back all changes to the database that
occurred since the last BEGIN
TRANSACTION statement was executed.
ROLLBACK WORK
SAVE
TRANSACTION
Sets a savepoint within a transaction. None
Miscellaneous Statements
EXECUTE Invokes a stored procedure. None
SET Sets query-processing options for the
duration of a work session.
None
UPDATE
STATISTICS
Updates all statistics associated with all
columns of a specified table.
UPDATE
STATISTICS
USE Causes SQL Server to use the specified
database.
CATALOG or
VOLUME
Table 4-16. Supported Transact-SQL Statements by Type (page 2 of 2)
Transact-SQL
Statement Description
Corresponding
NonStop SQL/MP
Statement