Skip to content

Instantly share code, notes, and snippets.

@FlameWolf

FlameWolf/gist:9a574df6390adb6989575db57524df47

Created March 12, 2026 13:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save FlameWolf/9a574df6390adb6989575db57524df47 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save FlameWolf/9a574df6390adb6989575db57524df47 to your computer and use it in GitHub Desktop.
Download ZIP
SELECT-DB-OBJECTS.sql
Raw
gistfile1.txt
WITH CTE AS
(
SELECT
SCHEMA_NAME(SysObjects.[schema_id]) AS SchemaName,
COALESCE(SysTableTypes.[name], SysObjects.[name]) AS ObjectName,
SysObjects.[type] AS ObjectType,
SysObjects.[type_desc] AS ObjectTypeDescription,
SysObjects.modify_date AS LastModifiedDate,
SysObjects.create_date AS CreationDate
FROM sys.objects AS SysObjects
LEFT JOIN sys.table_types AS SysTableTypes
ON SysTableTypes.type_table_object_id = SysObjects.[object_id]
WHERE SysObjects.is_ms_shipped = 0
)
SELECT
CONCAT(QUOTENAME(SchemaName), '.', QUOTENAME(ObjectName)) AS FullyQualifiedName,
*
FROM CTE
WHERE ObjectType IN ('FN', 'IF', 'P', 'TF', 'TT', 'U','V')
ORDER BY ObjectType, ObjectName;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment