USER_TABLES in MySQL
Date: October 21, 2006 08:23AM
I would like to know if there are equivalent tables for the oracle predefined tables: USER_TABLES, USER_TAB_COLUMNS, USER_CONS_COLUMNS and USER_CONSTRAINTS.
The thing is that I would like to write these trhee oracle queries in MySQL, could you give me a little piece of advice?:
SELECT TABLE_NAME ID, TABLE_NAME NAME
WHERE TABLE_NAME NOT LIKE '%$%'
SELECT UT.COLUMN_NAME NAME,DATA_TYPE TYPE
FROM user_tab_columns UT
WHERE UT.TABLE_NAME = ?
SELECT UCC.COLUMN_NAME NAME
FROM USER_CONS_COLUMNS UCC ,user_constraints UC
WHERE UCC.TABLE_NAME = ?
AND UC.TABLE_NAME = UCC.TABLE_NAME
AND UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME
AND UC.CONSTRAINT_TYPE = 'P'
Thanks in advance,
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.