SQL command to list all tables created

[SarahKate31]

I can't remember the command to list all of the tables you have created...I need to see how many I have and their names so I can delete them all...Thanks!

 

[carp]

SELECT table_name FROM user_tables;

 

[THoey]

Sarah, if you are going to drop all of the tables for a user, would it be easier to drop the user and all objects that belong to that user and then recreate the user and any objects you want to keep? Remember, this will drop all objects owned by that user, so make sure you have source scripts to recreate anything you want...

Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[abeerelnahas]

If you want to list all the tables you have created for a user try
login using username
then
SELECT * FROM TAB ;
or
SELECT * FROM CAT ;