We have a naming convention in the company to name all physical temporary and backup tables with underscore (_). Examples: _CustomerTemp or _OrderBck.
I would like to exclude those tables from being pushed to source control (TFS), but when I setup filter rules "exclude if object name begins with _" all tables are excluded.
I tried SQL language approach and specified [_] as exclude value (exclude if object name begins with [_]) to replicate following SQL statement (below, which works), but it didn't work at all and all tables are included and pushed to Source control.
SELECT * FROM sysobjects
WHERE xtype='U' and name NOT LIKE '[_]%'
When I look at filter settings script it stays:
Exclude where (@NAME LIKE '[_]%')
How do I exclude tables where names starts with _?