SQL Server Tip #1: Basic Table Template

SqlServerTip1_BasicTableTemplate.sql

CREATE TABLE tempdb.dbo.temp1
(
Temp1Id INT IDENTITY(1,1) NOT NULL
CONSTRAINT temp1PrimaryKey PRIMARY KEY CLUSTERED,
VALUE VARCHAR(25),
DateModified datetime2,
DateCreated datetime2 default getdate()
)
GO

CREATE TABLE tempdb.dbo.temp2
(
Temp2Id INT IDENTITY(1,1) NOT NULL
CONSTRAINT temp2PrimaryKey PRIMARY KEY CLUSTERED,
Temp1Id INT NOT NULL
CONSTRAINT Temp2Temp1ForeignKey FOREIGN KEY (Temp1Id)
REFERENCES dbo.temp1(Temp1Id),
VALUE VARCHAR(25) NULL,
DateModified datetime2,
DateCreated datetime2 default getdate()
)
GO