Skip to content

Instantly share code, notes, and snippets.

@brianvp
Created May 29, 2015 16:13
Show Gist options
  • Save brianvp/ba307d38476ec3287a83 to your computer and use it in GitHub Desktop.
Save brianvp/ba307d38476ec3287a83 to your computer and use it in GitHub Desktop.
SQL Server 2014 Code Snippet - Create new Tables
<?xml version="1.0" encoding="utf-8" ?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
<_locDefinition xmlns="urn:locstudio">
<_locDefault _loc="locNone" />
<_locTag _loc="locData">Title</_locTag>
<_locTag _loc="locData">Description</_locTag>
<_locTag _loc="locData">Author</_locTag>
<_locTag _loc="locData">ToolTip</_locTag>
</_locDefinition>
<CodeSnippet Format="1.0.0">
<Header>
<Title>Create Standard Tables</Title>
<Shortcut></Shortcut>
<Description>Creates Standard table.</Description>
<Author>Brian Vander Plaats</Author>
<SnippetTypes>
<SnippetType>Expansion</SnippetType>
</SnippetTypes>
</Header>
<Snippet>
<Declarations>
</Declarations>
<Code Language="SQL">
<![CDATA[
CREATE TABLE tempdb.dbo.temp1
(
Temp1_pk INT IDENTITY(1,1) NOT NULL
CONSTRAINT PK_dbo_Temp1 PRIMARY KEY CLUSTERED,
VALUE VARCHAR(25),
Date_Modified datetime2,
Date_Created datetime2 default getdate()
)
GO
CREATE TABLE tempdb.dbo.temp2
(
Temp2_pk INT IDENTITY(1,1) NOT NULL
CONSTRAINT pk_dbo_temp2 PRIMARY KEY CLUSTERED,
Temp1_fk INT NOT NULL
CONSTRAINT FK_dbo_Temp2_dbo_Temp1 FOREIGN KEY (Temp1_fk)
REFERENCES dbo.temp1(Temp1_pk),
VALUE VARCHAR(25) NULL,
Date_Modified datetime2,
Date_Created datetime2 default getdate()
)
GO
]]>
</Code>
</Snippet>
</CodeSnippet>
</CodeSnippets>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment