title: How to duplicate a Redshift table schema?
body: <p>I'm trying to duplicate a Redshift table including modifiers.</p>
  
  <p>I've tried using a CTAS statement and for some reason that fails to copy modifiers like <code>not null</code></p>
  
  <pre><code>create table public.my_table as (select * from public.my_old_table limit 1);
  </code></pre>
  
  <p>There also doesn't seem to be a way to alter the table to add modifiers after creating the table which leads me to believe that there isn't a way to duplicate a Redshift table schema except by running the original create table statement vs the CTAS statement.</p>