power designer 资料库表查询

select
objt.OBJT as objt_id,
objt.PVOB as objt_perid,
objt.POID as objt_origin_id,
objt.code as objt_code,
objt.name as objt_name,
txt.TDAT as objt_comment,
objtc.code as objtc_code,
objtc.name as objtc_name,
txtc.TDAT as objtc_comment,
ocrusr.name as objt_create_user,
objt.OCDT as objt_create_date,
oupusr.name as objt_modity_user,
objt.OMDT as objt_modify_date,
objt.CUSR as modelt_create_user,
objt.CDAT as modelt_create_date,
objt.MUSR as modelt_modify_user,
objt.MDAT as modelt_modify_date,
objtc.OMDT as objtc_modify_date,
objtc.CUSR as modelc_create_user,
objtc.CDAT as modelc_create_date,
objtc.MUSR as modelc_modify_user,
objtc.MDAT as modelc_modify_date
from
meta_database.pmobjt objt,
meta_database.pmclss obcls,
meta_database.pmuser ocrusr,
meta_database.pmuser oupusr,
meta_database.pmtext txt,
meta_database.pmrlsh prl,
meta_database.pmobjt objtc,
meta_database.pmtext txtc
where objt.clss=obcls.CLSS
and objt.OCUS=ocrusr.RUSR
and objt.OMUS=oupusr.RUSR
and objt.CMMT=txt.TXID
and objt.OBJT=prl.SRCE
and objtc.objt=prl.TRGT
and objtc.CMMT=txtc.TXID
and obcls.name in(‘Table‘)
order by objt.code,objt.OBJT

power designer 资料库表查询

原文：https://www.cnblogs.com/HondaHsu/p/14426342.html