code.delx.au - gnu-emacs-elpa/blob - packages/yasnippet/snippets/sql-mode/create

   1 # contributor: Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
   2 # name: create table ...
   3 # key: create
   4 # --
   5 CREATE TABLE [${1:dbo}].[${2:TableName}]
   6 (
   7                 ${3:Id}         ${4:INT IDENTITY(1,1)}          ${5:NOT NULL}
   8 $0
   9         CONSTRAINT [${6:PK_}] PRIMARY KEY ${7:CLUSTERED} ([$3])
  10 )
  11 GO