minisqlquery-master/src/MiniSqlQuery/Templates/Create Table.sql.mt at 6136600 · miniSql

miniSql

创建

zgc123@gmail.com authored at 11/19/2023 1:40:15 AM

225.00 B

History Blame Raw

Create Table.sql.mt
`#@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) )`

#@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)
)