SELECT	SESSIONPROPERTY('ANSI_PADDING')

SELECT name  column_name,
           CASE is_ansi_padded 
                      WHEN 1 THEN 'On' 
                      ELSE  'Off'
           AS [ANSI_PADDING]
FROM sys.all_columns
WHERE object_id = object_id(<table name>)

SELECT name  column_name,
           CASE is_ansi_padded 
                      WHEN 1 THEN 'On' 
                      ELSE  'Off'
           AS [ANSI_PADDING]
FROM sys.all_columns
WHERE object_id = object_id(<table name>)

SELECT
    name  column_name,
    CASE is_ansi_padded 
             WHEN 1 THEN 'On' 
             ELSE  'Off'
    AS [ANSI_PADDING]
FROM
    sys.columns
WHERE
    object_id = object_id(<schema.tablename>)