{{ model.title }}

by {{ model.createdBy }}
Just a way to list some SQL items
code
-- List tables
SELECT * FROM [INFORMATION_SCHEMA].[TABLES]

-- List columns
SELECT * FROM [sys].[columns]

-- List column defaults
SELECT s.[Name] as [Schema], t.[name] AS [TableName], c.[name] AS [ColumnName], d.[Name] AS [ConstraintName]
	FROM [sys].[all_columns] c 
	JOIN [sys].[tables] t ON t.[object_id] = c.[object_id] 
	JOIN [sys].[schemas] s ON s.[schema_id] = t.[schema_id] 
	JOIN [sys].[default_constraints] d ON c.[default_object_id] = d.[object_id]

-- List stored proceedures
SELECT * FROM [sys].[objects] WHERE [type] = 'P' AND [object_id] = OBJECT_ID('schema.name')
SELECT * FROM [INFORMATION_SCHEMA].[ROUTINES] WHERE [ROUTINE_TYPE] = 'PROCEDURE'

-- List functions
SELECT * FROM [INFORMATION_SCHEMA].[ROUTINES] WHERE [ROUTINE_TYPE] = 'FUNCTION'