view release on metacpan or  search on metacpan

bin/db-browser  view on Meta::CPAN

=back

=head3 Union Menu

=over

=item Subquery

=item CTE

=item Where

=item Parentheses

=back

Note: Parentheses are not available in C<SQLite> and C<Firebird>.

These settings are also valid when C<Intersect> or C<Except> is used.

=head3 Columns and Values

=over

=item

Extended Columns

If enabled, C<%%> is shown as an additional menu entry in the column menus. Selecting C<%%> lets one choose between the
available extensions.

=item

Extended Values

If enabled, then - in addition to constants - subqueries, functions and more (see the following list) are available for
the right side of operators. Places where extended values are available: C<WHERE>, C<HAVING>, C<SET> in update, and
C<WHEN>, C<THEN> and C<ELSE> in case expressions.

=item

Extended Arguments

If enabled, subqueries, functions and more (see the following list) are available for entering arguments in addition to
constants in the scalar and window functions.

This option can also be enabled later in the functions menu by selecting the prompt line.

=back

=head4 Column/Value/Argument Extensions

Not all of these extensions are available everywhere.

=over

=item Value

Enter a constant value.

If the data type is numeric or undefined and the literal looks like a number, it is not enclosed in quotation marks.
In all other cases, the literal is enclosed in quotation marks.

C<SQLite>: If the option C<sqlite_see_if_its_a_number> is enabled, values that look like numbers are not enclosed in
quotation marks; otherwise, they are.

To enter a value quoted manually, use the C<SQL> menu entry from the C<%%> menu.

=item SQL

Selecting C<SQL> opens the subqueries menu.

See L<Subquery> for the different possibilities to enter a subquery or any other SQL text.

Entries beginning with SELECT or WITH followed by a space are automatically enclosed in parentheses.

=item Scalar Functions

Selecting C<scalar()> opens the menu, where the user can choose from a list of scalar functions.

Extended arguments for scalar functions can be temporarily enabled by selecting the prompt line (I<Scalar functions:>)
of the scalar function menu.

C<DATEADD>, C<EXTRACT> and some other functions: use the keys C<Up-Arrow> and C<Down-Arrow> to choose one of the
predefined fields (in C<Value> if the extended arguments are enabled).

C<TO_EPOCH> and C<Oracle>: The argument I<Column type> can be any of the following: I<DATE>, I<TIMESTAMP> or
I<TIMESTAMP_TZ>. If the column type is I<DATE> or I<TIMESTAMP> the session timezone is used as timezone.

Scalar functions may not work with the C<ODBC> plugin.

=item Window Functions

Selecting C<win()> opens the menu, where the user can choose from a list of window functions.

=item Case Expression

Selecting C<case> opens the menu, where the user can build a C<CASE> expression.

=item Maths

Selecting C<math()> opens the menu, where the user can combine expressions with arithmetic operators.

=item Column

Selecting C<Column> opens the menu, where the user can choose a column.

By selecting C<%%> one can choose a column from a different table.

=item Set to C<NULL>

Available after the C<SET> in an C<UPDATE> statement.

=item )end

Close the IN operator parentheses.

=item mc

C<WHERE>: Use more than one column on the left-hand side of the operator.

bin/db-browser  view on Meta::CPAN

=item

GROUP BY

=item

HAVING

=item

ORDER BY

=back

Not all RDBMSs support aliases in GROUP BY and HAVING.

=head3 Identifiers

=over

=item

Qualified Table Names

=item

Quote Table Names

=item

Quote Column Names and Aliases

=back

C<SQLite>: If the current database has attached databases, the use of qualified table names is enabled automatically.

C<SQLite>: Database names in SQL statements (C<ATTACH DATABASE>) are always quoted.

C<Informix>: Set the C<DELIMIDENT> environment variable to allow quoted identifiers.

=head3 View Prefix

Enter a string that should be automatically placed in front of all view names.

=head3 Other

=over

=item

Subqueries created with the 'SQL Menu': Allow editing.

When enabled, subqueries created using the 'SQL Menu' can be edited before they are used.

=item

Pg: Convert to C<text> automatically when required.

If the driver is C<Pg>: Convert columns in string functions automatically to C<text> if the datatype of the column is
not a char like datatype. If the datatype is unknown and the value looks like a number, it is also converted to C<text>.

=back

=head2 Create-Table

=head3 Enable Options

=over

=item

Auto Increment

Enabling I<Auto Increment> makes the 'auto-increment primary key' option available when creating a table.

=item

Data Type Guessing

When this option is enabled and a table is created, C<SQL::Type::Guess> is used to guess the data types. These data types
are then used as defaults when the user is prompted for data types.

=item

Encode data for type guessing

If enabled, the data passed to C<SQL::Type::Guess> is encoded.

The setting of this option can affect the size of C<max> in C<varchar(max)> if strings contain multibyte characters.

=back

=head3 Add Form Fields

=over

=item

Table Constraint Fields

Specify the number of fields available for entering table constraints (0-9).

=item

Table Option Fields

Specify the number of fields available for entering table options (0-9).

=back

=head3 Auto Increment Column Name

Set the default value for the auto-increment primary key column name.

=head2 Output

=head3 Binary Filter

Set I<Binary filter> to C<NO>, C<BNRY>, or C<Hexadecimal>.