15 lines
No EOL
452 B
Transact-SQL
15 lines
No EOL
452 B
Transact-SQL
IF OBJECT_ID('dbo.SchemaVersion', 'U') IS NULL
|
|
BEGIN
|
|
CREATE TABLE dbo.SchemaVersion (
|
|
VersionNumber VARCHAR(20) NOT NULL PRIMARY KEY,
|
|
AppliedOn DATETIME2 NOT NULL DEFAULT GETDATE(),
|
|
AppliedBy VARCHAR(100) NOT NULL DEFAULT SUSER_SNAME(),
|
|
ScriptDescription VARCHAR(255) NULL
|
|
);
|
|
PRINT 'Table dbo.SchemaVersion created successfully.';
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
PRINT 'Table dbo.SchemaVersion already exists.';
|
|
END
|
|
GO |