Module Assign NameStore Dict Str Str Str Dict Str Str Str Str Str Str Str Str Dict Str Str Str Str Str Str Str Str Str Str Dict Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str
N/A N/A queries N/A column table system N/A head all unique sample select {column} from {schema}.{table} limit {n}; select {column} from {schema}.{table}; select distinct {column} from {schema}.{table}; select {column} from {schema}.{table} order by rand() limit {n}; N/A select head all unique sample select {columns} from {schema}.{table}; select * from {schema}.{table} limit {n}; select * from {schema}.{table}; select distinct {columns} from {schema}.{table}; select * from {schema}.{table} order by rand() limit {n}; N/A schema_no_system schema_with_system schema_specified foreign_keys_for_table foreign_keys_for_column ref_keys_for_table foreign_keys_for_db ref_keys_for_db 
                select table_schema
                    , table_name
                    , column_name
                    , data_type
                from
                    information_schema.columns
                where
                    table_schema not in ('information_schema', 'performance_schema', 'mysql')
                 
                select table_schema
                    , table_name
                    , column_name
                    , data_type
                from
                    information_schema.columns;
                 
                select table_schema
                    , table_name
                    , column_name
                    , udt_name
                from
                    information_schema.columns
                where table_schema in (%s);
                 
        select column_name
            , referenced_table_name
            , referenced_column_name
        from
            information_schema.key_column_usage
        where
            table_name = '{table}'
            and referenced_column_name IS NOT NULL
            and table_schema = '{table_schema}';
         
        select column_name
            , referenced_table_name
            , referenced_column_name
        from
            information_schema.key_column_usage
        where
            table_name = '{table}'
            and column_name = '{column}'
            and referenced_column_name IS NOT NULL
            and table_schema = '{table_schema}';
         
            select referenced_column_name
                , table_name
                , column_name
            from
                information_schema.key_column_usage
            where
                referenced_table_name = '{table}'
                and referenced_column_name IS NOT NULL
                and table_schema = '{table_schema}';
         
            select column_name
                , referenced_table_name
                , referenced_column_name
            FROM
                information_schema.key_column_usage
            WHERE referenced_column_name IS NOT NULL;
         
            SELECT referenced_column_name,
                   table_name,
                   column_name
            FROM
                information_schema.key_column_usage
            WHERE referenced_column_name IS NOT NULL;
        