How to list all table name?

[Former Member]

Hello Friends

How to list all table name?

From DB02, there are 69,739 tables in PRD, but only 69,678 tables in DEV. 61 difference.

I want to get the table name of these 61 tables. How to get it?

I tried use SQL command "select table_name from user_table", the results shows 70962 in PRD and 68480 in dev. The difference is 2482. I am confused.

Please help me to get the 61 table names.

Thank you.

Li

[former_member182034]

hi Li,

For Client Difference

You can get the table difference with clients with the help of SCU0.

for this , first you have to create a RFC(SM59) for both clients.

and

For Table Difference

You can get the tables difference with SCMP - View/Table Comparison.

Regards,

[Former Member]

Hello Li,

From db02 -> segments -> Detailed Analysis put the segment/Object is *

Thanks

Manas