-- maintyp table
#
SELECT id, name, dir, removeInd, type, isFinal, secureTransfer, lastModified, modifiedByGroup, modifiedById, cm from @main@ WHERE id=-1
#

-- props table
#
SELECT componentId, name, stringValue, numericValue, isNumeric FROM @props@ WHERE componentId=-1
#

-- access table
#
SELECT componentId, accessType, accessMode, principalGroupId, principalId from @access@ WHERE componentId=-1
#

-- owner table
#
SELECT componentId, principalGroupId, principalId FROM @owner@ WHERE componentId=-1
#

-- resource table
#
SELECT id, stringValue, numericValue, binaryValue, contentType, extension, binaryLength, resourceType, lastModified, c_constraints, removeTime from @resource@ where id=-1
#
#
SELECT componentId, categoryValues, resourcegroup, resourceId from @resourceref@ where componentId=-1
#
#
SELECT componentId, metaKey, metaValue from @metadata@ where componentId=-1
#
#
SELECT componentId, type, name, data from @publisher@ where componentId=-1
#
-- sensitive categories
#
select id, componentId, name, resourcegroup from @sensitiveCategories@ where id = -1
#

-- supported category values
#
select categoryId, categoryvalue from @supportedCategoryValues@ where categoryId = -1
#

-- lock table
#
SELECT component, owner, currentHolder, locktime, cm, wf from @lock@ where cm=-200
#
-- global lock table
#
SELECT component, owner, currentHolder, locktime, cm, wf from @globallock@ where cm=-200
#