How to fetch names of Table which contain a key or pattern from database(SQL Server) ?

First of all select your database using 'use' keyword in which you want to perform search operation













This query will give you all names of table which contain Aof.