Sanjeeb Sarangi - All Comments

re: SQL Query to list down the tables and all coumhs in database,

Onkar Ahire — Sat, 03 Oct 2009 07:22:21 GMT

Thanks for showing me Query...

arthur ruff — Wed, 23 Sep 2009 16:59:49 GMT

Have not tried it yet

amit gajera — Tue, 14 Jul 2009 04:43:24 GMT

plz i requir asp.net life cycle simple all step.

vivek — Sat, 23 May 2009 13:54:12 GMT

It's Working, Thanking U.

swati — Mon, 18 May 2009 12:48:34 GMT

hi nice work....

code worked well to me

Ravi Ranjan — Mon, 18 May 2009 05:35:56 GMT

Only Required to ListDown TableNAme

chandu — Wed, 15 Apr 2009 09:31:47 GMT

Good answer Keith, it works in sqlserver.

thank u.

nick_noouro — Fri, 10 Apr 2009 15:49:48 GMT

Prabhu — Fri, 27 Feb 2009 23:07:12 GMT

select * from all_tables

will list all the tables that the current user (with which you logged in) has access to.

select * from all_tables where owner = <schema_name>

will give the list of tables for the mentioned schema name (if you have access to it)

raja — Sat, 14 Feb 2009 04:34:37 GMT

plz i need urgently