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