valid_identifier_regex: Regex pattern to validate SQL identifier names

Description Usage Details Value Note Author(s) References Examples

Description

Returns a regular expression to validate unquoted SQL identifiers.

Usage

1

Details

Valid SQL identifiers must begin with an alphabetic character followed by alphanumeric characters or underscores "_".

Value

Character string with regular expression.

Note

The current implementation doesn't allow any other special characters in SQL identfiers or quoted SQL identifiers for safety reasons. In future releases, valid SQL identifiers might be defined depending on the target database system.

Author(s)

Uwe Block

References

ORACLE Database SQL Language Reference.

Examples

1

Example output

[1] "^[[:alpha:]][_[:alnum:]]*$"

lazysql documentation built on May 1, 2019, 9:45 p.m.