tags:

views:

805

answers:

2

If I do a Create Table If Not Exists, and a table with the same name exists with fewer rows (or columns), what would happen?

+3  A: 

Nothing. If the "IF Not Exists" clause fails, the rest of the create is skipped.

Bill the Lizard
+6  A: 

The table will not be created if a table with the same name already exists regardless of table layout.

Robert Gamble