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

sql sql-server-2008 varchar
Vivian River picture Vivian River · Apr 18, 2011 · Viewed 150.6k times · Source

Suppose that I have a SQL table that has a varchar[1000] field called "Remarks".

I would like to craft a single SQL statement, which when executed, will return 1000, or whatever the size of the varchar field might be changed to in the future.

Something like SELECT size(Remarks) FROM mytable.

How do I do this?

Answer

Neil Knight picture Neil Knight · Apr 18, 2011 
select column_name, data_type, character_maximum_length    
  from information_schema.columns  
 where table_name = 'myTable'

Related questions

Changing the maximum length of a varchar column?

I'm trying to update the length of a varchar column from 255 characters to 500 without losing the contents. I've dropped and re-created tables before but I've never been exposed to the alter statement which is what I believe I need to …

Read More
How to run a more than 8000 characters SQL statement from a variable?

I can use the following code for tiny little queries: DECLARE @sql VARCHAR(8000) SET @sql = 'SELECT * FROM myTable' Exec @sql The above method is very useful in order to maintain large amounts of code, especially when we need to make …

Read More
What does varchar(-1) mean?

What is the meaning of varchar(-1) in SQL Server 2008? Is it an alternative for varchar(max)?

Read More