Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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

Answers

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.