<p>I would like to do a lookup of tables in my SQL Server 2005 Express database based on table name. In <code>MySQL</code> I would use <code>SHOW TABLES LIKE "Datasheet%"</code>, but in <code>T-SQL</code> this throws an error (it tries to look for a <code>SHOW</code> stored procedure and fails).</p>

<p>Is this possible, and if so, how?</p>

Try this :
```
```
select * from information_schema.columns
where table_name = 'yourTableName'
```
```
also look for other
```
information_schema
```
views.