TSQL : Start Identity at 0 or 1

An identity column automatically increments by a set interval and a set starting point.

If you want to start your identity values at 1, then increment by 1…

CREATE TABLE [YourSchema].[YourTable](

[YourKeyColumn] [int] IDENTITY(1,1) NOT NULL.....

If you want to start your identity values at 0, then increment by 1…

CREATE TABLE [YourSchema].[YourTable](

[YourKeyColumn] [int] IDENTITY(0,1) NOT NULL.....

If you want to start your identity values at 0, then increment by 5…

CREATE TABLE [YourSchema].[YourTable](

[YourKeyColumn] [int] IDENTITY(0,5) NOT NULL.....

TSQL : Check if Table Exists…

You can get this from SQL Management Studio via the General scripts function however an outline is provided here for reference…useful when you want to check a table exists before doing something…
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[YourSchema].[YourTable]') AND type in (N'U'))
/* Do Something - Insert your code below */