有没有办法检查记录是否使用某些列的默认值？

SELECT COLUMN_NAME, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'your_database_name'
  AND TABLE_NAME = 'your_table_name'
  AND COLUMN_NAME = 'your_column_name';

SELECT name AS COLUMN_NAME, column_default AS COLUMN_DEFAULT
FROM sys.columns
WHERE object_id = OBJECT_ID('your_table_name')
  AND name = 'your_column_name';

SELECT COLUMN_NAME, DATA_DEFAULT
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'your_table_name'
  AND COLUMN_NAME = 'your_column_name';