Created
May 29, 2015 16:13
-
-
Save brianvp/ba307d38476ec3287a83 to your computer and use it in GitHub Desktop.
SQL Server 2014 Code Snippet - Create new Tables
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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