topic Re: how to find database table in Application Development and Automation Discussions

how to find database table

Former Member — Wed, 10 Sep 2008 05:09:36 GMT

I am having owners and table names.Now i want find out the tables which are not belongs to perticular owners.

pls can anyone tell me the table name where all database tables information will store.

so that i can write the select query to find perticular tables.

Regards

Haritha.

Former Member — Wed, 10 Sep 2008 05:13:58 GMT

Hi Sriharitha,

Refer the table DD02L for the list of all SAP Tables.

Regards,

Swapna.

Former Member — Wed, 10 Sep 2008 05:34:22 GMT

hi,

please refer the table DD02L for the list of table names.the field name is SQLTAB

Former Member — Wed, 10 Sep 2008 05:36:04 GMT

Thank for u r quick responce but i want know the owner of my tables that field is not in the table DDO2L.

So wt i need to do is i am having so many table i want to get the tables which r belongs to perticular owners.

Pls can u tell me how can i?

Regards.

Haritha.

Former Member — Wed, 10 Sep 2008 05:47:06 GMT

Hi,

SQLTAB is the field for finding clu/pooled but i need to find owner of the field.OWNER field is no there in DD02L.

Regards

Haritha.