title: Creating tables with SQL Server 2012 Management Studio
body: <p>I'm trying to create a table in SQL Server 2012 Management Studio.</p>
  
  <p>I want to create a table with columns: <code>category</code>, <code>customer</code>, <code>Costume</code>, <code>Payment</code>, and <code>rental</code>. </p>
  
  <p>Here is the SQL I have so far:</p>
  
  <pre><code>CREATE TABLE dbo.CATEGORY
  (
      CATEGORY_ID     CHAR(5)     PRIMARY KEY,
      CATEGORY_DESC   CHAR(50)    NOT NULL
  );
  
  CREATE TABLE dbo.COSTUME
  (
      Costume_ID              CHAR(5), 
      Costume_Desc            CHAR(50), 
      Costume_Size            CHAR(5),
      Costume_RentalPricE     DECIMAL(12,2),
      Category_ID             CHAR(5)
  );
  
  CREATE TABLE dbo.CUSTOMER
  (
      Customer_ID         CHAR(5),
      Customer_LastName   CHAR(50),
      Customer_FirstName  CHAR(50),
      Customer_Address    CHAR(30),
      Customer_City       CHAR(50),
      Customer_State      CHAR(2),
      Customer_Zip        CHAR(10),
      Customer_Phone      CHAR(10),
      Category_ID         CHAR(5)
  );
  
  CREATE TABLE dbo.Payment
  (
      Payment_ID          CHAR(5),
      Customer_ID         CHAR(5),
      Payment_Date        DATE,
      Payment_Amount      DECIMAL(12,2),
      Payment_Comment     VARCHAR,
  );
  
  CREATE TABLE dbo.Rental
  (
      Rental_ID       --it says this needs to be Long integer for field size?
      Customer_ID         CHAR(5),
      Costume_ID          CHAR(5),
      Rental_Date         DATE,   
      Rental_DueDate      DATE,
      Rental_CheckIn      --YES OR NO? i'M NOT SURE HOW TO DO THIS. 
      Rental_Penalty      DECIMAL(12,2)
  );
  </code></pre>
  
  <p>How do I create a Boolean column and a long for fields?</p>