æ¹æ³å¦ä¸ï¼ä»¥oracle为ä¾ï¼
select * from all_tables WHERE owner='SCOTT' ;æè
SELECT * FROM DBA_TABLES WHERE OWNER='SCOTT';
æ°æ®åå
¸è§å¾
表åå
DBA_TABLESãALL_TABLESåUSER_TABLESæ¾ç¤ºäºæå
³æ°æ®åºè¡¨çä¸è¬ä¿¡æ¯ã
DBA_TAB_COLUMNSãALL_TAB_COLUMNSåUSER_TAB_COLUMNSæ¾ç¤ºäºæ¯ä¸ªæ°æ®åºè¡¨çåçä¿¡æ¯ã
注æï¼DBA_OBJECTSãALL_OBJECTSåUSER_OBJECTSæ¾ç¤ºäºæ¨¡å¼å¯¹è±¡çä¿¡æ¯ï¼å
æ¬è¡¨ã
温馨提示:答案为网友推荐,仅供参考