How to search for tables in MS SQL server?

You may use the following query to fetch a list of tables matching certain criterion/ criteria:

SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'
AS tableName
FROM sys.tables where name like '%course%';

Tags: Microsoft, Wild-card Search, SQL, Oracle, MySQL

Related