Get the column Length of a table in sql.

 

You can make use of COL_LENGTH  function which returns the length of particular column

 

Syntax :

 

Col_length ('tablename', 'columnname')

 

Ex.

 

SELECT     COL_LENGTH('employee', 'location') AS Expr1

Ebook Download
View all
Learn
View all