Hi,my questions is :
CREATE TABLE dwaine.mytab (col1 INT, col2 INT)
INSERT INTO dwaine.mytab VALUES (1,2)
INSERT INTO dwaine.mytab VALUES (4,3)
ROLLBACK
The table created or not ? i know insert will rollback but i am not very clear that the table created ?
thanks

the CREATE TABLE is rollbacked, too.

And the reason is that the CREATE TABLE statement is - like any other SQL statement - executed in a transaction. Thus, if you roll back the transaction, the create table must be undone as well.

If the statements is :
CREATE TABLE dwaine.mytab (col1 INT, col2 INT)
INSERT INTO dwaine.mytab VALUES (1,2)
INSERT INTO dwaine.mytab VALUES (4,3)
ROLLBACK
COMMIT
The table created or not ?
Thanks !

The table does no longer exist after the ROLLBACK.
the following COMMIT has no effects in your scenario.