miniSql

创建
zgc123@gmail.com authored at 11/19/2023 1:40:15 AM
6136600
Tree
0 Parent(s)
Summary: 1 changed files with 9 additions and 0 deletions.
Added +9 -0
Added +9 -0
diff --git a/minisqlquery-master/src/MiniSqlQuery/Templates/Create Table.sql.mt b/minisqlquery-master/src/MiniSqlQuery/Templates/Create Table.sql.mt
new file mode 100644
index 0000000..dcf75f1
--- /dev/null
+++ b/minisqlquery-master/src/MiniSqlQuery/Templates/Create Table.sql.mt
@@ -0,0 +1,9 @@
+#@get TableName
+IF OBJECT_ID('${TableName}', 'U') IS NOT NULL
+  DROP TABLE [${TableName}]
+
+CREATE TABLE [${TableName}]
+(
+	${TableName}Id INT IDENTITY NOT NULL, 
+    CONSTRAINT PK_${TableName}Id PRIMARY KEY (${TableName}Id)
+)