summaryrefslogtreecommitdiffstats
path: root/emacs.d/snippets/text-mode/sql-mode/constraint
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--emacs.d/snippets/text-mode/sql-mode/constraint4
-rw-r--r--emacs.d/snippets/text-mode/sql-mode/constraint.14
2 files changed, 8 insertions, 0 deletions
diff --git a/emacs.d/snippets/text-mode/sql-mode/constraint b/emacs.d/snippets/text-mode/sql-mode/constraint
new file mode 100644
index 0000000..989e508
--- /dev/null
+++ b/emacs.d/snippets/text-mode/sql-mode/constraint
@@ -0,0 +1,4 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : CONSTRAINT [..] PRIMARY KEY ...
+# --
+CONSTRAINT [${1:PK_Name}] PRIMARY KEY ${2:CLUSTERED} ([${3:ColumnName}])
diff --git a/emacs.d/snippets/text-mode/sql-mode/constraint.1 b/emacs.d/snippets/text-mode/sql-mode/constraint.1
new file mode 100644
index 0000000..98d89f0
--- /dev/null
+++ b/emacs.d/snippets/text-mode/sql-mode/constraint.1
@@ -0,0 +1,4 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : CONSTRAINT [..] FOREIGN KEY ...
+# --
+CONSTRAINT [${1:FK_Name}] FOREIGN KEY ${2:CLUSTERED} ([${3:ColumnName}])