-- ----------------------------------------------------- -- View cacheObjectSortV -- ----------------------------------------------------- DROP VIEW IF EXISTS cacheObjectSortV ; DROP TABLE IF EXISTS cacheObjectSortV; create OR REPLACE view cacheObjectSortV as select objectId, sortOptionId, sorter from cacheObjectSortT;