| Title |
Test
Find
Pattern Title
|
| Expression |
^[a-zA-Z_]{1}[a-zA-Z0-9_@$#]*$ |
| Description |
This Regex matches valid SQL identifiers, including names for Stored Procedures and the like. Note that local variables/parameters (which begin with an "@") will not match this Regex, nor will temporary objects (beginning with a "#"), or global temporary objects (beginning with "##"). All other valid identifiers/variables/table names/stored procedure names/columns etc., will match. Please let me know if you find this useful or have any complaints - [email protected]. |
| Matches |
upApplicationReadContacts | _Application_ReadContacts | a_45$#z |
| Non-Matches |
upApplication ReadContacts | $Application_ReadContacts | a_45%$#z |
| Author |
Rating:
Geoff Williams
|
| Source |
http://www.primalblaze.com |
| Your Rating |
|
Title: Super!
Name: Liesha
Date: 3/18/2008 9:22:25 AM
Comment:
A little customisation and viola!!
