Regex pattern to validate SQL identifier names

Description

Returns a regular expression to validate unquoted SQL identifiers.

Usage

valid_identifier_regex()

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

lazysql::valid_identifier_regex()

Results