Appendix D: Using Sybase Mode Commands


Transact-SQL commands

Many T-SQL commands use table names of up to three parts. ODBC supports these three-part naming convention:

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. Table D-1 lists each command, its restrictions (if any), and its description.

Table D-1: Transact-SQL commands

Command

Restrictions

Description

Page

alter table (core)

core

Adds new columns to 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

§

create view

core

Creates a new view

§

delete

minimum

Removes rows from a table

§

delete (cursor event)

core

Removes a row from a table (if row was made current by a read cursor)

§

delete (dynamic event)

minimum

Removes rows from a table

§

drop index

core

Removes an index from a table in the current database

§

drop table

minimum

Removes a table definition from the database

§

drop view

core

Removes one or more views from the current database

§

execute

Runs a system procedure or user-defined storage procedure

§

grant

core

Assigns authorization to users

§

insert

minimum

Adds new rows to a table or view

§

prepare transaction

Determines whether a server is prepared to commit a transaction

§

revoke

core

Revokes permissions from users

§

rollback transaction

Rolls back a user-specified 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 or modifying data

§

update (cursor event)

core

Changes data in a row made current by a read cursor

§

update (dynamic event)

core

Changes data in existing rows of a referenced table

§

use

Specifies the database in which you want to work

§