SQL SERVER | Elencare le tabelle e le viste presenti nel database

9 giugno 2014 1 min di lettura Database Microsoft SQL Server Windows

SELECT Name, CASE WHEN Type = ‘U’ THEN ‘Table’ ELSE ‘View’ END AS ‘Type’, Create\_Date, Modify\_Date FROM SYS.OBJECTS WHERE TYPE IN (N’U’, N’V’) ORDER BY Name ASC

SELECT Name, CASE WHEN Type = 'U' THEN 'Table' ELSE 'View' END AS 'Type', Create_Date, Modify_Date
FROM SYS.OBJECTS WHERE TYPE IN (N'U', N'V')
ORDER BY Name ASC