原始資料
==============================
-- 連接 TestDB 資料庫
USE TestDB;
GO
/*
多行註解-1
多行註解-2
多行註解-3
多行註解-4
*/
-- Drop Table
IF ( EXISTS ( SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'Test' ) )
BEGIN
TRUNCATE TABLE Test;
DROP TABLE Test;
END;
GO
-- Create Table
CREATE TABLE Test
(
Id INT PRIMARY KEY
IDENTITY(1, 1)
NOT NULL ,
[Name] NVARCHAR(100) NULL
);
GO
==============================
處理結果
==============================
USE TestDB;
GO
IF ( EXISTS ( SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'Test' ) )
BEGIN
TRUNCATE TABLE Test;
DROP TABLE Test;
END;
GO
CREATE TABLE Test
(
Id INT PRIMARY KEY
IDENTITY(1, 1)
NOT NULL ,
[Name] NVARCHAR(100) NULL
);
GO
==============================