title: When to CREATE TABLE AS SELECT versus CREATE TABLE LIKE?
body: <p>I can "copy" a table using:<br>
  <code>CREATE TABLE copy LIKE original_table</code><br>
  and<br>
  <code>CREATE TABLE copy as select * from original_table</code>  </p>
  
  <p>In the latter case only the data are copied but not e.g primary keys etc.<br>
  So I was wondering when would I prefer using a <code>select as</code>?  </p>