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
2008-10-27 15:56:37
+6
A:
The table will not be created if a table with the same name already exists regardless of table layout.
Robert Gamble
2008-10-27 15:57:23