How to get COLUMN LENGTH in SQL

preview_player
Показать описание
This video is about how to get COLUMN LENGTH in SQL.

Script:
SELECT COLUMN_NAME, character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'persons'

Keywords:
how to get COLUMN length in SQL,column length sql,column length in sql,sql column length,length of columns in sql,get column length sql,get column length in sql,get sql column length,length of columns in table sql,sql length of column table,length of column in table,sql length of column in table, sql column length, sql column length query, sql column length, sql column length query, column length sql, column length sql, column length in sql, column length sql query, columns length sql, column length sql query, field length sql, sql server, learn sql, sql
Рекомендации по теме
Комментарии
Автор

i tried the same but, for me it is fetching 0 rows. even though the table has records for all the fields.

positivity
Автор

hi ! how can we get 4th employee details based on length of the name without using window functions?

vandanavarakala