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 6-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
|