Get Schema Name and Table Name - SQL Server

To get schema Name ;

SELECT SCHEMA_NAME(schema_id)

AS SchemaTable

FROM sys.tables

  

To get Table Name ;

 

SELECT name

AS SchemaTable

FROM sys.tables