單憑個人感覺，模式在達夢中屬于邏輯對象合集，回頭再看資料
應該是一個用戶可以對應多個模式

問題來了，模式的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';