Skip to main content
Question

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

  • August 26, 2020
  • 2 replies
  • 8 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
  • Participating Frequently
  • August 26, 2020

select * from projections where projection_schema = 'schema_name' ;


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • August 26, 2020

@Vertica_Curtis Thank you very much