Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018The following snippet generates a SQL Server View that displays information about the parameters that need to be passed in to System Objects. The data type information that is returned in this view is human readable (i.e. `nvarchar(200) NULL`), rather than the numeric type … Continue reading Querying Stored Procedure and System Function Parameter Information
Tag: CASE
Return DDL from METADATA
Tested on server version: SQL Server 2016 Developer Edition Reference info accurate on: January, 2018 The following script demonstrates how to generate each column's DDL from metadata in Transact-SQL. Example Output: T-SQL [code language="sql"] DECLARE @rundate datetime2 = getdate(); DECLARE @default_collation nvarchar(128); -- = 'SQL_Latin1_General_CP1_CI_AS'; SELECT @default_collation = convert(sysname, serverproperty('collation')) SELECT TABLE_CATALOG ,TABLE_SCHEMA ,TABLE_NAME ,COLUMN_NAME … Continue reading Return DDL from METADATA