Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SQL create tables reference
CREATE TABLE sometable
(
[id] [uniqueidentifier] NOT NULL
CONSTRAINT [DF_sometable_id] DEFAULT (newid()), /* This isn't required for DEFAULT */
[userid] [uniqueidentifier] NOT NULL,
[accountid] [uniqueidentifier] NOT NULL,
[activated] [bit] NOT NULL,
[activatedon] [datetime] NULL,
[email] [nvarchar](128) NOT NULL,
[key] [varchar](32) NOT NULL,
PRIMARY KEY NONCLUSTERED (id), /* DONT USE CLUSTERED FOR uniqueidentifier */
CONSTRAINT FK_sometable_userid FOREIGN KEY(userid) REFERENCES users (id),
CONSTRAINT FK_sometable_accountid FOREIGN KEY(accountid) REFERENCES accounts (id),
)
CREATE NONCLUSTERED INDEX [idx_anothertable] ON [dbo].[anothertable]
(
[sometypeid] ASC,
[fileid] ASC,
[layoutid] ASC
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.