Transact-SQL Commands

Many Transact-SQL commands use table names of up to three parts.

ODBC supports three-part naming convention:

location_name (DBMS name, current server)
authorization_ID (owner)
table_name or view_name

If the first or second parts are not present, they are omitted. The access service supports three-part objects in all cases in which a SQL object is required in a SQL statement. In doing so, the SQL transformation code either drops the qualifier or performs the correct action with the qualifier.

When the access service receives a use database_name in sybase mode, it captures the name and sets a member of smConnectionConcrete with the database name so that SQL_GETINFO and SQL_DATABASE_NAME pass back the current database name.

alter table (core)
Adds new columns and constraints, changes or drops constraints, and partitions or unpartitions an existing table.
begin transaction (Transact-SQL only)
Marks the starting point of a user-defined transaction.
commit transaction (Transact-SQL only)
Marks the ending point of a user-defined transaction.
create index (core)
Creates an index on one or more columns in a table.
create table (minimum)
Creates new tables and optional integrity constants.
create view (core)
Creates a new view.
delete (minimum)
Removes rows from a table.
delete (core)
Removes a row from a table (cursor event). The affected row must be made current by a read cursor.
delete (minimum)
Removes rows from a table (dynamic event).
drop index (core)
Removes an index from a table in the current database.
drop table (minimum)
Removes a table definition and all of its data, indexes, triggers, and permissions from the database.
drop view (core)
Removes one or more views from the current database.
execute
Runs a system procedure or a user-defined stored procedure.
grant (core)
Assigns authorization to users.
insert (minimum)
Adds new rows to a table or view.
prepare transaction
Used by a DB-Library™ in a two-phase commit application to determine whether a server is prepared to commit a transaction.
revoke (core)
Revokes permissions from users.
rollback transaction
Rolls back a user-specified transaction to the last savepoint inside the transaction or to the beginning of the transaction.
select (minimum)
Retrieves rows from database objects.
truncate table (extension using where 1=1)
Removes all rows from a table.
update (core)
Changes existing rows by adding data or modifying existing data.
update (core)
Changes data in a row made current by a read cursor by adding data or modifying existing data (cursor event).
update (core)
Changes data in existing rows of the referenced table (dynamic event).
use
Specifies the database with which you want to work.