cancel
Showing results for 
Search instead for 
Did you mean: 

how to search coulumn name

Former Member
0 Kudos

hi

I have some problem, anybody can help  ?- how I can get all table name where have some column name, how I can in maxdb create this specific select sql request.

select "table_name" from DB where column_name = "%AAA%"

thank you.

Accepted Solutions (1)

Accepted Solutions (1)

thorsten_zielke
Contributor
0 Kudos

Hi,

use 'domain.columns' for this e.g.
select * from domain.columns where columnname like '%AAA%'

Thorsten

Former Member
0 Kudos

ok, tnx,

I see - this search in abap stack, but how I can search in java stack ( I use DBACOCKPIT transaction for connect to java stack DB)

JamesZ
Advisor
Advisor
0 Kudos

Hi Baji,

in java stack, you can integrate your database into a abap dbacockpit (solution manager). Or you can use the same query as Thorsten mentioned.

In integrate the database into dbacockpit, you can check note:

1371928 - DBA Cockpit: SAP MaxDB/liveCache as remote database

Best regards,

James

Answers (0)