how to list all tables in my account?# Database - 数据库
ak
1 楼
could i list all tables in my account? what's the command?
i am a new user.
thanks!
i am a new user.
thanks!
m*t
2 楼
I believe this is database-dependent.
【在 ak 的大作中提到】
: could i list all tables in my account? what's the command?
: i am a new user.
: thanks!
g*o
3 楼
Try this two
1). select OBJECT_NAME from USER_OBJECTS where OBJECT_TYPE='TABLE';
2). select OBJECT_NAME from ALL_OBJECTS where OBJECT_TYPE='TABLE' and OWNER =
'your_userid';
【在 ak 的大作中提到】
: could i list all tables in my account? what's the command?
: i am a new user.
: thanks!
1). select OBJECT_NAME from USER_OBJECTS where OBJECT_TYPE='TABLE';
2). select OBJECT_NAME from ALL_OBJECTS where OBJECT_TYPE='TABLE' and OWNER =
'your_userid';
【在 ak 的大作中提到】
: could i list all tables in my account? what's the command?
: i am a new user.
: thanks!
F*a
4 楼
The simplest is to use the ALL_TABLES:
select TABLE_NAME from ALL_TABLES where OWNER = 'XXX';
=
【在 g***o 的大作中提到】
: Try this two
: 1). select OBJECT_NAME from USER_OBJECTS where OBJECT_TYPE='TABLE';
: 2). select OBJECT_NAME from ALL_OBJECTS where OBJECT_TYPE='TABLE' and OWNER =
: 'your_userid';
select TABLE_NAME from ALL_TABLES where OWNER = 'XXX';
=
【在 g***o 的大作中提到】
: Try this two
: 1). select OBJECT_NAME from USER_OBJECTS where OBJECT_TYPE='TABLE';
: 2). select OBJECT_NAME from ALL_OBJECTS where OBJECT_TYPE='TABLE' and OWNER =
: 'your_userid';
a*c
5 楼
Select tname from tab;
=
【在 g***o 的大作中提到】
: Try this two
: 1). select OBJECT_NAME from USER_OBJECTS where OBJECT_TYPE='TABLE';
: 2). select OBJECT_NAME from ALL_OBJECTS where OBJECT_TYPE='TABLE' and OWNER =
: 'your_userid';
=
【在 g***o 的大作中提到】
: Try this two
: 1). select OBJECT_NAME from USER_OBJECTS where OBJECT_TYPE='TABLE';
: 2). select OBJECT_NAME from ALL_OBJECTS where OBJECT_TYPE='TABLE' and OWNER =
: 'your_userid';
m*t
6 楼
if it's oracle,
select table_name from user_tables;
would be my favorite.
【在 F***a 的大作中提到】
: The simplest is to use the ALL_TABLES:
: select TABLE_NAME from ALL_TABLES where OWNER = 'XXX';
:
: =
相关阅读
网上哪有文章介绍 SQL server 的 TDATA? sql server 面试题 （5）error file或者exception fileMySQL founder quits Sun(ZZ)问个初级Lotus notes的问题请问一个初级问题求救！求.NET工作Oracle in Windowssmall problem about DAOrecursive query help我找工作，如果有空缺请说一下。coolbid, 问个问题这面试题,一个问题都不懂啊Rookie's question againHow to Import a Datatable as fast as possible?in Oracle, what is it called for /*+ index(xxx) */问一个小问题Which design is better?Oracle and HP(ZZ)周末包子谢帖及请教高手