1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[SQL] Extract/Get the table name and their respective columns used in a view from a query in...

Discussão em 'Outras Linguagens' iniciado por Stack, Setembro 24, 2021.

  1. Stack

    Stack Membro Participativo

    Let us take the following MYSQL query written in BigQuery for creating a view.

    SELECT a.col1,
    a.col2,
    a.col3,
    b.col1,
    b.col2,
    b.col3,
    c.col1,
    c.col2
    FROM project_name_dataset_table_a a
    INNER JOIN project_name_dataset_table_b b ON a.col1 = b.col1
    INNER JOIN project_name_dataset_table_c c ON a.col2 = c.col2


    Below is the required output format or similar. Final Format Required or any similar will be fine

    Basically i have to prepare a document which will contain all the information of the views created and the tables and their respective columns used in it.

    Continue reading...

Compartilhe esta Página