Skip to main content
Question

How can I check what projections all tables in the schema have?

  • Aug 26, 2020 1:45 AM UTC
  • 2 replies
  • 14 views
HyeontaeJu
Forum|alt.badge.img+2

My question same with the title
How can I check what projections all tables in the schema have?
Please, give me a wisdom T _ T

    2 replies

    Vertica_Curtis
    Forum|alt.badge.img+1
    • Vertica_Curtis
    • Participating Frequently
    • Aug 26, 2020 2:42 AM UTC

    select * from projections where projection_schema = 'schema_name' ;

    HyeontaeJu
    Forum|alt.badge.img+2
    • HyeontaeJu
    • Author
    • Participating Frequently
    • Aug 26, 2020 7:45 AM UTC

    @Vertica_Curtis Thank you very much

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement