SQL SERVER INFORMATION SCHEMA METADATA FOR TABLES AND COLUMNS

SQL SERVER INFORMATION SCHEMA METADATA FOR TABLES AND COLUMNS

-- THEORY

-- SELECT * FROM INFORMATION_SCHEMA.[TYPE]

-- EXAMPLE

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS;

-- RESULT A REPORT ON TABLES AND VIEWS WITH THEIR DATA TYPES AND STRUCTURE

-- SQL SERVER IS NULL REPLACEMENT VALUE

-- THEORY

-- SELECT [NULL VALUE] AS [ALIAS NAME], ISNULL(NULL,'REPLACEMENT TEXT') AS [ALIAS NAME];

-- EXAMPLE

SELECT NULL AS [NULL], ISNULL(NULL,'THIS IS EMPTY') AS [REPLACEMENT VALUE FOR NULL];