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
Tabelas dentro de um Database SQL Server
top of page
bottom of page
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