SQL Column width from delimited text


Version: 1.0
Category:
Scripts
Python
Requirements:
Seller:
Price:
-
System:
Rating:
4.9
License:

Description - SQL Column width from delimited text



When loading text files into database tables (MSSQL in this example), the source columns often do not match the table definition. This script was written to find the maximum length of each column in a delimited text file, then modify the a table Create DDL file to make each character column wide enough, so truncation errors do not occur.



More in Python-SQL Column width from delimited text

Column Width Delimited Text Sql Column Width