db2中syscat有哪些重要的表?
select name from sysibm.systables where type='t' and creator='db2admin' type:數(shù)據(jù)庫(kù)表用t表示;數(shù)據(jù)庫(kù)視圖用v表示 creator:數(shù)據(jù)庫(kù)對(duì)象的創(chuàng)建者 select tabname from syscat.tables where tabschema = current schema ;// 獲取當(dāng)前模式下面的所有用戶表