CREATE TABLE ... AS SELECT ... WITH NO DATA

First part of the Create Table As Select process
this only works when no data is specified
passes all new tests
Commented out and extra lines can be removed.