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 ASCGuide pratiche di Linux, Windows, Database, Sviluppo Web e molto 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