Filter tables that start with _ (underscore)
StormRider
Posts: 26
How do I filter tables that start with an _ (underscore)?
just using _ doesn't work, as it filters everything. I tried [_] (sql style escape) and _ (regex style escape), and they didn't work either. Ideas?
SQL Source Control version 3.7.5.328
just using _ doesn't work, as it filters everything. I tried [_] (sql style escape) and _ (regex style escape), and they didn't work either. Ideas?
SQL Source Control version 3.7.5.328
Comments
Unfortunately there is currently no way to escape the underscore character. This is a bug with reference SC-5894.
If it is acceptable, you could move the object to a new schema and then filter by schema name. I know this isn't ideal but there isn't a good workaround at the moment.
I will let you know when the bug is fixed. Apologies.
Redgate Software
Redgate Software
I installed 3.8.11.103 and I'm still unable to filter tables that start with underscore.
Hi,
I suspect you might be encountering another bug that is related to underscores that was fixed in a later version. Can you try installing 3.8.19? Here's a link - ftp://support.red-gate.com/patches/SQLS ... 19.130.exe
Redgate Software