How to get the size of a varchar[n] field in one SQL statement?

by 
select column_name, data_type, character_maximum_length    
  from information_schema.columns  
 where table_name="myTable"

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Unable to Subtract Dates SQL Server
  3. Insert local .csv data in remote SQL Server via already working connection string
  4. what is the reason behind this error in case statement
  5. Syntax combine two stored procedure into one [closed]
  6. How to delete duplicate rows in SQL Server?
  7. CROSS JOIN vs INNER JOIN in SQL
  8. How to cast the DateTime to Time
  9. How can I schedule a job to run a SQL query daily?
  10. Reset identity seed after deleting records in SQL Server
  11. How to avoid the “divide by zero” error in SQL?
  12. Multiple INSERT statements vs. single INSERT with multiple VALUES
  13. Real life example, when to use OUTER / CROSS APPLY in SQL
  14. Common Table Expression, why semicolon?
  15. T-SQL split string based on delimiter
  16. SQL Server 2008: how do I grant privileges to a username?
  17. Splitting delimited values in a SQL column into multiple rows
  18. How do I find duplicates across multiple columns?
  19. Generate script in SQL Server Management Studio
  20. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  21. Why are logical reads for windowed aggregate functions so high?
  22. Stored procedure that exports data into csv files only exports to one file
  23. SQL Server: should I use information_schema tables over sys tables?
  24. Finding rows that don’t contain numeric data in Oracle
  25. TSQL – How to use GO inside of a BEGIN .. END block?
  26. SQL take just the numeric values from a varchar
  27. How to execute a stored procedure inside a select query
  28. Single or multiple databases
  29. SQL Unpivot multiple columns Data
  30. Foreign Key Not Populating with Primary Key Values

Leave a Comment