Create table as in SQL Server Management Studio
<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>