List table with scheme (where in table names)

list-table-with-scheme.sql

select schema_name(t.schema_id) + '.' +
       t.name as table_name,
       t.create_date,
       t.modify_date
from sys.tables t
where t.name IN (
'ABC'
)
order by table_name;