招标网上的项目好中标吗_宁波网站建设系统介绍_自制网站_樱花12e56

单凭个人感觉，模式在达梦中属于逻辑对象合集，回头再看资料
应该是一个用户可以对应多个模式

问题来了，模式的ID和用户的ID一样吗？
不一样

SELECT USER_ID,USERNAME FROM DBA_USERS WHERE USERNAME='TEST1';
SELECT ID AS SCHID, NAME AS SCHEMA_NAME FROM SYSOBJECTS WHERE TYPE$ = 'SCH' AND NAME = 'TEST1';

知道schid在sysobjects中大有用途

select name,id,pid,INDEXDEF(ID,0)TXT from SYSOBJECTS where TYPE$ ='TABOBJ' and SUBTYPE$='INDEX' and schid=(SELECT ID FROM SYSOBJECTS WHERE TYPE$ = 'SCH' AND NAME = 'TEST1');

简洁版的查询无效索引

select u.name owner , o.name index_name, o.id object_id from  SYSOBJECTS o ,(SELECT ID, name  FROM SYSOBJECTS WHERE TYPE$ = 'SCH' AND NAME = 'TEST1') u where u.id=o.schid and  o.TYPE$ ='TABOBJ' and o.SUBTYPE$='INDEX' and o.valid='N';