summaryrefslogtreecommitdiffstats
path: root/emacs.d/lisp/yasnippet/snippets/sql-mode/create
diff options
context:
space:
mode:
Diffstat (limited to 'emacs.d/lisp/yasnippet/snippets/sql-mode/create')
-rw-r--r--emacs.d/lisp/yasnippet/snippets/sql-mode/create10
1 files changed, 10 insertions, 0 deletions
diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/create b/emacs.d/lisp/yasnippet/snippets/sql-mode/create
new file mode 100644
index 0000000..a34624d
--- /dev/null
+++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/create
@@ -0,0 +1,10 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : create table ...
+# --
+CREATE TABLE [${1:dbo}].[${2:TableName}]
+(
+ ${3:Id} ${4:INT IDENTITY(1,1)} ${5:NOT NULL}
+$0
+ CONSTRAINT [${6:PK_}] PRIMARY KEY ${7:CLUSTERED} ([$3])
+)
+GO