检查某个业务对象被哪些字段引用

FROM (SELECT SYSOBJECTS.NAME AS TABLE_NAME, SYSCOLUMNS.NAME AS COLUMN_NAME, SYSCOLUMNS.COLID AS COLUMN_ID, SYSTYPES.NAME AS DATA_TYPE, SYSCOLUMNS.LENGTH AS DATA_LENGTH,
SYSCOLUMNS.PREC AS DATA_PRECISION, SYSCOLUMNS.SCALE AS DATA_SCALE, SYSCOLUMNS.ISNULLABLE AS NULLABLE, SYSCOMMENTS.TEXT AS DATA_DEFAULT
FROM SYSCOLUMNS
INNER JOIN SYSOBJECTS ON SYSCOLUMNS.ID = SYSOBJECTS.ID AND SYSOBJECTS.XTYPE = 'U'
INNER JOIN SYSTYPES ON SYSCOLUMNS.XUSERTYPE = SYSTYPES.XUSERTYPE
LEFT JOIN SYSCOMMENTS ON SYSCOLUMNS.CDEFAULT = SYSCOMMENTS.ID) u
INNER JOIN (SELECT FOBJECTTYPEID, FDEVTYPE, FINHERITPATH, UPPER(FTABLENAME) ftablename, UPPER(FFIELDNAME) ffieldname,
FBASEOBJECTID fbaseobjectid, T_META_OBJECTTYPE_L.FNAME
检查某个业务对象被哪些字段引用
SELECT v.* FROM (SELECT SYSOBJECTS.NAME AS TABLE_NAME, SYSCOLUMNS.NAME AS COLUMN_NAME, SYSCOLUMNS.COLID AS COLUMN_ID,...
点击下载文档文档为doc格式
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。
上一篇
已经是第一篇



