title: Create table as in SQL Server Management Studio
body: <p>I do have a basic question. I have changed from PLSQL to SQL Server lately and I am struggling with basic task such is CREATE TABLE. </p>
  
  <p>In PLSQL is normal to write </p>
  
  <pre><code> create table TIRED_LIKE_DOG as select * database;
  </code></pre>
  
  <p>How can I create table in SQL Server 2014 Management Studio?</p>
  
  <p>Is it really that I first need to create table like</p>
  
  <pre><code>CREATE TABLE dbo.COSTUME
  (
      text CHAR(5), -- need commas
      Price4 DECIMAL(12,2), 
      Price2 DECIMAL(12,2),
      price  DECIMAL(12,2), -- Number isn't a valid SQL        Server data type  
      Category_ID CHAR(5)
   );
  </code></pre>
  
  <p>and then I have to select in some table?</p>
  
  <p>Thank you. </p>
  
  <p>Have a nice day</p>