title: CREATE TABLE statement question in T-SQL
body: <p>I am working on a pomotion database and below is what my CREATE TABLE steatment looks like:</p>
  
  <pre><code>CREATE TABLE [dbo].[sponsors]
  (
      [InstId] [bigint] NOT NULL,
      [EncryptedData] [varbinary](44) NOT NULL,
      [HashedData] [varbinary](22) NOT NULL,
      [JobId] [bigint] NOT NULL,
      CONSTRAINT [PK_sponsors] PRIMARY KEY CLUSTERED 
      (
          [InstId] ASC
      )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  
  SET ANSI_PADDING OFF
  GO
  
  ALTER TABLE [dbo].[sponsors]  WITH CHECK ADD  CONSTRAINT [FK_sponsors_jobs] FOREIGN KEY([JobId])
  REFERENCES [dbo].[jobs] ([Id])
  GO
  
  ALTER TABLE [dbo].[sponsors] CHECK CONSTRAINT [FK_sponsors_jobs]
  GO
  
  ALTER TABLE [dbo].[sponsors]  WITH CHECK ADD  CONSTRAINT [FK_sponsors_titles] FOREIGN KEY([TId])
  REFERENCES [dbo].[titles] ([TId])
  GO
  
  ALTER TABLE [dbo].[sponsors] CHECK CONSTRAINT [FK_sponsors_titles]
  GO
  </code></pre>
  
  <p>And I'd like to get rid of ALTER TABLE statements and make them part of CREATE TABLE
  statements, I know how to do the most but not sure how to get CHECK CONSTRAINT during
  create table, does anyone have experience with this? or know how to?  </p>