main
1use [gorilla]
2GO
3
4PRINT 'Creating table FOO'
5CREATE TABLE [dbo].[Foo](
6 [ID] [bigint] IDENTITY (1,1) NOT NULL,
7 [Name] [varchar](100) NOT NULL,
8 [Age] [int] NOT NULL,
9 [Version] [bigint] DEFAULT 1 NOT NULL
10) ON [PRIMARY]
11GO
12ALTER TABLE [dbo].[Foo] WITH NOCHECK ADD
13 CONSTRAINT [PK_FOO] PRIMARY KEY CLUSTERED
14 (
15 [ID]
16 ) ON [PRIMARY]
17GO