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
Appunti, stralci di programmazione e altro
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