RSqlParser (version 1.5)

get_all_tables_with_alias: Get the names of the tables with alias present in the sql

Description

This function takes sql statement and returns the list of names of tables and alias for that table, if any present in the sql statement. The first column represent table name and second column represents alias.

Usage

get_all_tables_with_alias(sql)

Arguments

sql

statement

Value

names of tables with alias present in sql statement

Examples

# NOT RUN {
get_all_tables_with_alias("Select p from abc where xyz = 5")
# }