I have a SQL Server with numeric types for few columns.
When getting a table structure, I have the following results:
Query:
SELECT *
FROM DB.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TABLE'
AND DATA_TYPE = 'numeric'
The result is the following (truncated):
CHARACTER_MAXIMUM_LENGTH NUMERIC_PRECISION NUMERIC_SCALE
NULL 2 0
Will the value CHARACTER_MAXIMUM_LENGTH
always be NULL for a numeric ? Don't scale and precision impact the character length of the value ?
Best Answer
From this wonderful website:
INFORMATION_SCHEMA.COLUMNS
CHARACTER_MAXIMUM_LENGTH
Data Types (Transact-SQL).