Hi!
I have a table temp with path varchar(1000). I reduced the path size with:
After I did this the table size actually grew. I reduced again to varchar(4000 and the table size grew again.
Is there another action I should take after adjusting the column size? I was hoping to reduce the size of the table, but it is increasing.
Thanks!
I have a table temp with path varchar(1000). I reduced the path size with:
Code:
alter table temp
alter column temp varchar(500)
After I did this the table size actually grew. I reduced again to varchar(4000 and the table size grew again.
Is there another action I should take after adjusting the column size? I was hoping to reduce the size of the table, but it is increasing.
Thanks!