ÿþCREATE DATABASE "dum"

PATH 'c:\dbpath\dum'

UNENCRYPTED CATALOG

!

CREATE TABLE "TestIgnore"

(

"Name" VARCHAR(10) COLLATE "ANSI_CI"

)

!

CREATE TABLE "TestSave"

(

"ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,

"Name" VARCHAR(10) COLLATE "ANSI_CI"

)

!

BACKUP DATABASE "dum"

AS "dum Backup"

TO STORE "Backup"

TABLES "TestSave"

INCLUDE CATALOG

!

ALTER TABLE "TestIgnore"

ALTER COLUMN "Name" AS VARCHAR(30) COLLATE "ANSI_CI"

!

RESTORE DATABASE "dum"

FROM "dum Backup"

IN STORE "LodgicalSolution-Backup"

INCLUDE CATALOG

!

VERIFY TABLE TESTIGNORE