get_summary_codes: Generate SQL summary in various DBMS

In casualcomputer/sql.mechanic: SQL Query Generator for Data Quality Assurance

Generate SQL summary in various DBMS

Description

This function takes a character string as an argument and returns a character string that stores SQL scripts that generate detailed table summaries of the table corresponding to target_path. The outputs of the function are automatically copied to the clipboard, which can then be run in the interface of various database management systems (e.g. Netezza, Microsoft SQL Server, DB2, etc.).

Usage

get_summary_codes(target_path, show_codes=FALSE, type="basic", dbtype="Netezza",quote_table_name=FALSE)

Arguments

target_path	character string: location of the table, i.e., "database_name.schema_name.table_name"
show_codes	Boolean: set to TRUE to print out results, FALSE otherwise
type	character string: exact matching to one of c("basic", "advanced")
dbtype	character string: exact matching to one of c("Netezza", "MSSQL")
quote_table_name	Boolean: wrap quotation marks around the table name, if set to TRUE; otherwise, FALSE

Examples

#SQL codes for basic summary, Netezza database
get_summary_codes("DB_NAME.SCHEMA_NAME.TABLE_NAME",
                   type="basic", dbtype="Netezza",quote_table_name=FALSE)


#SQL codes for advanced summary, Netezza database
get_summary_codes("DB_NAME.SCHEMA_NAME.TABLE_NAME",
                  type="advanced", dbtype="Netezza",quote_table_name=FALSE)


#SQL codes for basic summary, Microsoft SQL Server
get_summary_codes("DB_NAME.SCHEMA_NAME.TABLE_NAME",
                   type="basic", dbtype="MSSQL",quote_table_name=FALSE)


#SQL codes for advanced summary, Microsoft SQL Server
get_summary_codes("DB_NAME.SCHEMA_NAME.TABLE_NAME",
                   type="advanced", dbtype="MSSQL",quote_table_name=FALSE)

casualcomputer/sql.mechanic documentation built on March 11, 2023, 1:01 a.m.