MS SQL template for creating new tables

new-table-template.sql

-- GUID as ID
CREATE TABLE [dbo].[TableName1]
(
    [PrimaryKeyName] UNIQUEIDENTIFIER NOT NULL
        CONSTRAINT [PK_dbo.TableName1] PRIMARY KEY CLUSTERED
        CONSTRAINT [DF_dbo.TableName1_PrimaryKeyName] DEFAULT NEWSEQUENTIALID(),
    [ForeignKeyName] UNIQUEIDENTIFIER NOT NULL
        CONSTRAINT [FK_dbo.TableName1_dbo.TableName2_ForeignKeyName] FOREIGN KEY ([ForeignKeyName])
            REFERENCES [dbo].[TableName2] ([TableName2ColumnName]),
--     IsActive BIT NOT NULL,
);
GO

-- Integer as ID
CREATE TABLE [dbo].[TableName1]
(
    [Id] INT IDENTITY (1, 1) NOT NULL
        CONSTRAINT [PK_TableName1] PRIMARY KEY CLUSTERED,
    [ForeignKeyName] UNIQUEIDENTIFIER NOT NULL
        CONSTRAINT [FK_TableName1_TableName2_ForeignKeyName] FOREIGN KEY ([ForeignKeyName])
            REFERENCES [dbo].[TableName2] ([TableName2ColumnName]),
--     IsActive BIT NOT NULL,
);
GO