Need to retrieve particular string from all tables and get table names

SK21SK21 Vertica Customer

Please help me in building a query to retrieve table names from db
which contains 10 digit phone numbers in any column.
Numbers are in numeric format an could be of 12 digit also but most of them are have 10 numeric digits only.

Best Answers


  • SK21SK21 Vertica Customer

    Thanks @Jim_Knicely
    Also let me know How to find out all the tables with no data.
    Tables can be in various schemas for eg-A,B,C are tables. X and Y are schemas
    A& B doesn't have any data and A is present in X schema and B is present in Y schema.

    Please let me know the query for this or any other way.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file