Launching a SaaS?·Collect waitlist signups before you build — before.run
regex.to logoregex.to
SandboxPatternsDetectDocsChangelog
Database
#sql
#database
#identifier
#table

SQL Identifier

Validates SQL table, column, and schema names (unquoted or quoted with double quotes or backticks).

✓ ORM field validation✓ SQL query builder linter✓ Database migration tool
/
/
Safe
Test String
4 matches
[…]Character class […]— Matches any single character listed in this set
a-za-z— a-z — range from 'a' to 'z'
A-ZA-Z— A-Z — range from 'A' to 'Z'
__— '_' — literal character
[…]*Character class […]— Matches any single character listed in this set — repeated zero or more times (greedy) · * — zero or more times (greedy)
a-za-z— a-z — range from 'a' to 'z'
A-ZA-Z— A-Z — range from 'A' to 'Z'
0-90-9— 0-9 — range from '0' to '9'
__— '_' — literal character
||— | — alternation: matches expression on left OR right
""— '"' — literal character
[…]Character class […]— Matches any single character listed in this set
a-za-z— a-z — range from 'a' to 'z'
A-ZA-Z— A-Z — range from 'A' to 'Z'
__— '_' — literal character
[…]*Character class […]— Matches any single character listed in this set — repeated zero or more times (greedy) · * — zero or more times (greedy)
a-za-z— a-z — range from 'a' to 'z'
A-ZA-Z— A-Z — range from 'A' to 'Z'
0-90-9— 0-9 — range from '0' to '9'
__— '_' — literal character
""— '"' — literal character
||— | — alternation: matches expression on left OR right
``— '`' — literal character
[…]Character class […]— Matches any single character listed in this set
a-za-z— a-z — range from 'a' to 'z'
A-ZA-Z— A-Z — range from 'A' to 'Z'
__— '_' — literal character
[…]*Character class […]— Matches any single character listed in this set — repeated zero or more times (greedy) · * — zero or more times (greedy)
a-za-z— a-z — range from 'a' to 'z'
A-ZA-Z— A-Z — range from 'A' to 'Z'
0-90-9— 0-9 — range from '0' to '9'
__— '_' — literal character
``— '`' — literal character
Pattern: 72 charsInput: 52 chars
100% client-side · private

✓ Valid Examples

  • user_accounts
  • "order_items"
  • `customer_id`
  • first_name

✗ Invalid Examples

  • 123user
  • user-name
  • table;DROP TABLE users;
  • "unmatched_quote

Usage & Integration

Validate SQL Identifier natively in your backend or frontend without copying regex strings.

Node / Edge

import { validate } from '@regexto/validators';

validate('sql-identifier', '...');

Python

from regexto_validators import validate

validate("sql-identifier", "...")

Go

import "github.com/regex-to/validators-go"

valid, err := validators.Validate("sql-identifier", "...")

PHP

use RegexTo\Validators\Validator;

Validator::validate('sql-identifier', '...');

Rust

use regexto_validators::validate;

let is_valid = validate("sql-identifier", "...").unwrap();