Posts by Emerson • 1 point
1 post
-
0
votes5
answers36671
viewsA: How to get the total character size of an SQL column?
IF ((SELECT character_maximum_length FROM information_schema.columns WHERE (table_name = 'SUC_CONFIG') AND (COLUMN_NAME = 'SUC_CHAVE')) < 100) BEGIN ALTER TABLE SUC_CONFIG ALTER COLUMN…