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';
:
: =
相关阅读
Mysql limitsRe: 为什么有的电影必须要去电影院看?如何画双线?Urgent: TSP Files!!!!!certificate? Help please.Perl/CGI & MysqlSQL*Loader的一个问题Question about Oracle Driver下学期选了一们数据库的课multicolumn primary key ?A Question about Transactions in MS Access2000下连接mysql的问题DB2问题向高手请教a simpler sQL question, high help please!!!!SQL求救,helpsql high hand please help.Which server shoule I useHelp on Oracle!!from where can i get the acamedic info on DatabasSpecial character in insert values