最简单的方法是使用 LEN() 函数,如下例所示:
SELECT CustomerName,LEN(Address) as LengthOfAddress
FROM Customers;
所以代码应该是:
SELECT COLUMN_NAME, LEN(COLUMN_NAME) as NAME_LENGTH,
DATA_TYPE, LEN(DATA_TYPE) as DATA_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'tableName';