"localhost:/firebird/data/ILICHEVSK2.FDB". Представления

DESKSTORAGES

Описание

(Нет описания для представления DESKSTORAGES)

Поля

Триггеры

(Нет триггеров для представления DESKSTORAGES)

Определение

CREATE VIEW DESKSTORAGES(
    STORAGEID,
    STORAGEPARENTID,
    STORAGESHORTNAME,
    STORAGENAME,
    STORAGECONTROLNAME,
    STORAGETYPEID,
    STORAGEPLATFORMTYPEID,
    STORAGEUSERID,
    COMMENT)
AS
select STORAGELIST.STORAGEID, STORAGELIST.STORAGEPARENTID, STORAGELIST.STORAGESHORTNAME,
    STORAGELIST.STORAGENAME, STORAGELIST.STORAGECONTROLNAME, STORAGELIST.STORAGETYPEID,
--  STORAGELIST.STORAGEstoringtypeid,
    STORAGELIST.STORAGEPLATFORMTYPEID, STORAGELIST.STORAGEUSERID, STORAGELIST.COMMENT
  from STORAGE STORAGELIST
  where (STORAGELIST.STORAGETYPEID in (1,9))
    or ((STORAGELIST.STORAGEPARENTID is not null)
        and (exists(select * from STORAGE PARENTSTORAGE
               where (PARENTSTORAGE.STORAGETYPEID in (1,9))
                 and (PARENTSTORAGE.STORAGEID = STORAGELIST.STORAGEPARENTID))))
;