SQL : Get a list of tables,views and sequences for a given user

| No Comments
This SQL Snippet get a list of all the tables under a user:

select * from user_objects where object_type = 'TABLE';

This SQL Snippet will get you a list of all the sequences in a DB Schema for the user tables

select * from user_sequences


This SQL Snippet will get you a list of all the view in a DB Schema for the user tables

select * from user_views;

Happy Coding :)

Leave a comment

Pages

About this Entry

This page contains a single entry by Armaghan published on October 9, 2009 4:02 PM.

Finding out the Oracle Version using SQL was the previous entry in this blog.

SQL User queries in Oracle is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.