The following query can be used to find the current maximum length of data that is stored in any column, currently. UR is used just for performance.
select max (length(trim (my_column))) from my_table with UR
UR= Uncommitted Read
WITH UR can be specified only if the result table is read-only.[My Video Promotion]
More from: SQL Code
- How to setup and run the Microsoft’s Command Line BCP Utility Without Installing SQL Server Client?
- Utility Class For Getting SQL Connection and Closing It
- Dropping Stored Procedure and Granting Execute Permission
- Finding MAX length of the data in DB column
- SQL – How To Find The Physical Location Of MySQL Database (Data Location)
- Quick SQL Reference – Find Duplicate Data In A Table Using Having Clause
- 005: MySQL – Selecting a set of random rows from a table
- SQL – Finding Nth Highest Row In DB Table
- SQL – How To Retrieve Data With Maximum Length?