Question
How can I do the equivalent of "SHOW TABLES" in T-SQL?
I would like to do a lookup of tables in my SQL Server 2005 Express database based on table name. In MySQL
I would use SHOW TABLES LIKE "Datasheet%"
, but in T-SQL
this throws an error (it tries to look for a SHOW
stored procedure and fails).
Is this possible, and if so, how?
47 95432
47