title: Shortcut to Assign Multiple Foreign Keys Using Keyword CONSTRAINT
body: <p>Currently, I have the following code in my SQLQuery:</p>
  
  <pre><code>CREATE TABLE OrderTable (
      OrderNumber varchar(3) NOT NULL,
      Date_Time datetime NOT NULL,
      WaitID varchar(7) NOT NULL,
      CashID varchar(7),
      TableNumber varchar(3) NOT NULL,
      CONSTRAINT PK_Order PRIMARY KEY (OrderNumber, Date_Time),
      CONSTRAINT FK_WaitID FOREIGN KEY (WaitID) REFERENCES WaiterWaitress(ID),
      CONSTRAINT FK_CashID FOREIGN KEY (CashID) REFERENCES Cashier(ID),
      CONSTRAINT FK_TableNumber FOREIGN KEY (TableNumber) REFERENCES RestTable(TableNumber)
  );
  </code></pre>
  
  <p>I had to retype the <code>CONSTRAINT ... FOREIGN KEY ... REFERENCES ...</code> three times. Is there a shortcut to this while still maintaining the ability to name the foreign key (i.e. <code>FK_WaitID</code>)?</p>