RegExLib.com - The first Regular Expression Library on the Web!

Please support RegExLib Sponsors

Sponsors

Regular Expression Details

Title Test Find SQL Object Name Match
Expression
(((\[?(?<Database>[\w]+)\]?)?\.)?(\[?(?<Owner>[\w]+)\]?)?\.)?\[?(?<Object>[\w]+)\]?
Description
This returns the different parts of an Object Name (Database.Owner.Object). This can be used for matching or pulling out the different pieces.
Matches
[Table], Table, [Db].[Owner].[Table], [owner].[Table], ..[Table], or any combination there of...
Non-Matches
None
Author Rating: Not yet rated. Tim McCurdy
Source
Your Rating
Bad Good

Enter New Comment

Title

Name

Comment

Spammers suck - we apologize. Please enter the text shown below to enable your comment (not case sensitive - try as many times as you need to if the first ones are too hard):

Existing User Comments

Copyright © 2001-2025, RegexAdvice.com | ASP.NET Tutorials