Using Sybase Mode commands

This chapter describes the Transact-SQL recognized in sybase mode and the corresponding target SQL the service library generates.

This chapter covers the Transact-SQL commands listed in the following table.

Transact-SQL commands
Command	Restrictions	Description	Location
alter table	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


	Expand Search