Appendix D: Using Sybase Mode Commands

Transact-SQL commands

Many Transact-SQL commands use table names of up to three parts. ODBC supports the following 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. The following table 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	§

View this book as PDF