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