Equivalent of Access Tabledefs Collection

[BobLoblaws]

I am wondering what the equivalent of the Access tabledefs collection is in SQL Server.

Ideally, I would like to do a 'SELECT * FROM tabledefs' that returns all the tables in a database.

 

[JFoushee]

Try this SQL command:

USE (database_name)
SELECT table_name
FROM information_schema.tables
WHERE table_type = 'Base Table'