CREATE TABLE [dbo].[MyTable] (
[TableID] bigint IDENTITY(1, 1),
[TableName] nvarchar(50) NOT NULL,
[Created] datetime2(7) NOT NULL DEFAULT (getutcdate()),
[CreatedBy] uniqueidentifier NOT NULL,
[Modified] datetime2(7) NULL,
[ModifiedBy] uniqueidentifier NULL,
[Deleted] datetime2(7) NULL,
[DeletedBy] uniqueidentifier NULL,
[DeletedReason] nvarchar(255) NULL
)