Hi,
HeidiSQL is using a SQL like
SELECT VIEW_DEFINITION
FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME='XXX'
AND TABLE_SCHEMA='XXX';
for getting view's definition, but INFORMATION_SCHEMA has a column limit of 4000, which cause truncation of the view definition. The correct SQL to get the full definition is
SELECT MODS.DEFINITION
FROM SYS.OBJECTS OBJ
JOIN SYS.SQL_MODULES MODS
ON OBJ.OBJECT_ID = MODS.OBJECT_ID
WHERE OBJ.TYPE = 'V'
AND OBJ.NAME = 'CIMA_MEDICAMENTOS'
Regards,
Fernando