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