List names of all tables in a SQL Server schema

List names of all tables in a SQL Server schema

1. First Select the Database and press New Query Icon

2. Show you New Query Window

3. Use that Command Here

Filter all Tables and Views Using that Schema

SELECT * FROM INFORMATION_SCHEMA.TABLES

Filter Base Table Names Only use that Schema    

SELECT * FROM INFORMATION_SCHEMA.TABLES 

WHERE TABLE_TYPE='BASE TABLE' 

Output: