select URI_NAME,
OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
CREATED_ON, CREATE_MODE, JSON_DESCRIPTOR
from XDB.JSON$COLLECTION_METADATA
where OWNER = USER
View Text - HTML Formatted
SELECT URI_NAME ,
OBJECT_TYPE , OBJECT_SCHEMA , OBJECT_NAME ,
CREATED_ON , CREATE_MODE , JSON_DESCRIPTOR
FROM XDB.JSON$COLLECTION_METADATA
WHERE OWNER = USER