Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Cergy
    Posts
    65

    Question Unanswered: How can I list my tables ?

    Is there a equivalent to MySQL Show Tables ?
    I want to list all the tables in my DB.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    select table_name from user_tables;

  3. #3
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136
    select * from ALL_ALL_TABLES;
    -- Description of all object and relational tables accessible to the user

    select * from COLS;
    -- Columns of user's tables, views and clusters


    select * from dict;
    -- List of all internal tables of the database
    Regards,
    Julia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •