how to show all tables in ms sql code example Example: show tables sql server USE YOUR_DATABASE_NAME SELECT * FROM INFORMATION_SCHEMA.TABLES