Skip to Content
avatar image
Former Member

how to search coulumn name

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 20, 2015 at 03:29 PM

    Hi,

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

    Thorsten

    Add comment
    10|10000 characters needed characters exceeded

    • 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