If I do Create a table, if it does not exist , and a table with the same name exists with fewer rows (or columns), what will happen?
A table will not be created if a table with the same name already exists regardless of the location of the table.
Nothing. If the IF Not Exists clause fails, the rest of the creation is skipped.