/SqlServerTip1_BasicTableTemplate.sql
Created Oct 7, 2015
SQL Server Tip #1: Basic Table Template
| 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment