Vytvo°enφ SQL skriptu

SpuÜt∞nφ
Hlavnφ menu -> Report -> Ulo₧it SQL script...

Aplikace umo₧≥uje pro vybranΘ databßzovΘ servery viz. dialog V²b∞r databßzovΘho serveru vygenerovat script v jazyce SQL.

Postup
1.Z menu otev°ete standardnφ dialog, ve kterΘm urΦφte nßzev cφlovΘho souboru a mφsto, kde se mß ulo₧it.
2.Po zmßΦknutφ tlaΦφtka "Ok" se do p°φsluÜnΘho souboru vygeneruje script v jazyce SQL.

SpuÜt∞nφ
Hlavnφ menu -> Report -> U₧ivatelskΘ vsuvky do scriptu...

Pokud pot°ebujete p°ed vygenerovan² script p°ed°atit konstantnφ text, stejn∞ jako za script p°ipojit m∙₧ete vyu₧φt tΘto funkce. Po otev°enφ dialogu vlo₧te do p°φsluÜn²ch textov²ch polφ po₧adovanΘ texty. P°i ka₧dΘm generovßnφ SQL scriptu budou do tohoto scriptu automaticky p°idßny.

Ukßzka vygenerovanΘho scriptu pro MS SQL Server

connect testbase
go

CREATE TABLE Emploee (
   EmploeeID INT NOT NULL,
   LastName VARCHAR (20) NOT NULL,
   FirstName VARCHAR (15) NOT NULL,
   Birthdate DATETIME NOT NULL,
   Street VARCHAR (20) NULL,
   City VARCHAR (20) NULL,
   HomePhone VARCHAR (20) NULL,
   Photo IMAGE NULL,
   EmploeeIDReportsTo INT NULL
)
go

CREATE UNIQUE INDEX IPK_Emploee ON Emploee (EmploeeID ASC)
go
ALTER TABLE Emploee ADD PRIMARY KEY (EmploeeID)
go

CREATE TABLE Project (
   ProjectID INT NOT NULL,
   ProjectName VARCHAR (20) NULL,
   PrCatID INT NOT NULL,
   ManagerID INT NOT NULL,
   AssistentID INT NOT NULL,
   StartDate DATETIME NULL
)
go

CREATE UNIQUE INDEX IPK_Project ON Project (ProjectID ASC)
go
ALTER TABLE Project ADD PRIMARY KEY (ProjectID)
go

CREATE TABLE ProjectCategory (
   PrCatID INT NOT NULL,
   PrCatDescription VARCHAR (30) NULL
)
go

CREATE UNIQUE INDEX IPK_ProjectCategory ON ProjectCategory (PrCatID ASC)
go
ALTER TABLE ProjectCategory ADD PRIMARY KEY (PrCatID)
go


ALTER TABLE Emploee ADD FOREIGN KEY EmploeeEmploee (EmploeeIDReportsTo)
   REFERENCES Emploee ON DELETE RESTRICT
go
ALTER TABLE Project ADD FOREIGN KEY ManagerOfProject (ManagerID)
   REFERENCES Emploee ON DELETE RESTRICT
go
ALTER TABLE Project ADD FOREIGN KEY AssistentOfProject (AssistentID)
   REFERENCES Emploee ON DELETE RESTRICT
go
ALTER TABLE Project ADD FOREIGN KEY ProjectCategory (PrCatID)
   REFERENCES ProjectCategory ON DELETE RESTRICT
go




disconnect testbase
go