Options

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

HyeontaeJuHyeontaeJu Vertica Customer ✭
in General Discussion

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

Best Answer

  • Options
    Vertica_CurtisVertica_Curtis Employee
    Answer ✓

    select * from projections where projection_schema = 'schema_name' ;

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...