SELECT O.NAME AS OBJECT_NAME
, M.DEFINITION AS SCRIPT_CREATE
, REPLACE(M.DEFINITION, 'CREATE', CONCAT(CHAR(10), 'GO', CHAR(10), 'ALTER')) AS SCRIPT_ALTER
, O.CREATE_DATE
, O.MODIFY_DATE
FROM SYS.SQL_MODULES M
JOIN SYS.OBJECTS O ON M.OBJECT_ID = O.OBJECT_ID
--WHERE O.TYPE = 'P'
--WHERE O.TYPE = 'V'
WHERE O.TYPE = 'FN' AND O.NAME <> 'fn_diagramobjects';
The object extraction script
|
2018.05.31 15:01:48
|
2018.06.09 19:29:15
|
373
|
Aiden
Total of Attached file
0.00 Bytes of 0 files
2020.10.28
2020.08.20
2019.02.21
2018.06.11
2018.05.31
2018.01.12
2018.01.03
2017.10.23
2012.10.29
2012.10.19