select g.file_group_name, v.version_name,
v.version_id, f.file_name, f.file_dir_obj, f.file_type,
f.file_size, f.file_blocksize, f.user_comment
from "_USER_FILE_GROUPS" g, sys.fgr$_file_group_files f,
sys.fgr$_file_group_versions v
where f.version_guid = v.version_guid and v.file_group_id = g.file_group_id
SELECT G.FILE_GROUP_NAME
, V.VERSION_NAME
,
V.VERSION_ID
, F.FILE_NAME
, F.FILE_DIR_OBJ
, F.FILE_TYPE
,
F.FILE_SIZE
, F.FILE_BLOCKSIZE
, F.USER_COMMENT
FROM "_USER_FILE_GROUPS" G
, SYS.FGR$_FILE_GROUP_FILES F
,
SYS.FGR$_FILE_GROUP_VERSIONS V
WHERE F.VERSION_GUID = V.VERSION_GUID
AND V.FILE_GROUP_ID = G.FILE_GROUP_ID
|
|
|