Post reply

List all tables with a certain string

  • December 18, 2020 at 8:56 am

    #3821912

    Hi,

    I want to list al tables that contains only _ar_ in the name (archive tables)

    I have tried the following script

    Select name from sys.tables where name like '%_ar_%'

    but when i get the result i also see tables like abc_yard_abc and i only want to have tables like abc_ar_abc

     

  • December 18, 2020 at 9:33 am

    #3821938

    Your problem here is that the underscore character is itself a wildcard in T-SQL, matching any single character. That explains the results you are seeing.

    The solution is to ESCAPE the wildcard. Something (rather inelegant) like this (untested):

    Select name 
    from sys.tables 
    where name like '%|_ar|_%' ESCAPE '|';

    • This reply was modified 3 years, 11 months ago by  Phil Parkin.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 18, 2020 at 9:36 am

    #3821940

    Thanks Phil it seems to work !

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply