Standard transformations for T-SQL commands

Standard transformations are provided for the commands listed in the following table. Only those portions of the T-SQL syntax that can be directly translated into target DBMS syntax are transformed.

**Table 5-1: Standard transformations for T-SQL commands**
Command	Description of transformation
alter table	Adds new columns to an existing table
begin transaction	Begins a new transaction
commit transaction	Commits all work performed for this transaction
create index	Creates a new index on a table
create table	Creates new tables
create view	Creates a new view
delete	Deletes rows from a table
delete (cursor)	Removes rows from a table
delete (dynamic)	Removes rows from a table
drop index	Removes an index from a table
drop table	Removes a table
drop view	Removes one or more views
execute	Runs system or user-defined stored procedures.
grant	Assigns authorizations to users
insert	Adds new rows to a table or view
insert bulk	(Currently not supported)
prepare transaction	Prepares to commit a transaction
revoke	Revokes permission from users
rollback transaction	Rolls back or aborts the current transaction
select	Retrieves rows from database objects
truncate table	Truncates a table by removing all rows (this statement is not logged and is not part of any transaction)
update	Adds or modifies data in existing rows
update (cursor)	Positional update: changes data in row made current by a read cursor
update (dynamic)	Dynamic update: changes data in existing rows
use	Accesses an existing database