Tabelas dentro de um Database SQL Server

USE CORPORE

SELECT name,

FORMAT(create_date, 'dd/MM/yyyy') as create_date,

FORMAT(modify_date, 'dd/MM/yyyy') as modify_date,

modify_date

FROM sys.tables

ORDER BY name