Changing column width
Alex_Kuznetsov
Posts: 2
Suppose I have a lot of columns with similar names and types:
CREATE TABLE SomeTable1(Code VARCHAR(2), ...
CREATE TABLE SomeTable2(Code VARCHAR(2), ...
CREATE TABLE SomeTable3(Code VARCHAR(2), ...
Also I have a lot of stored procedures with the following parameter:
@Code VARCHAR(2)
Suppose I need to increase the width of just one such column to, say, VARCHAR(5). Clearly I need to change some of my parameters too. I think Refactor cannot help me in doing this, correct?
CREATE TABLE SomeTable1(Code VARCHAR(2), ...
CREATE TABLE SomeTable2(Code VARCHAR(2), ...
CREATE TABLE SomeTable3(Code VARCHAR(2), ...
Also I have a lot of stored procedures with the following parameter:
@Code VARCHAR(2)
Suppose I need to increase the width of just one such column to, say, VARCHAR(5). Clearly I need to change some of my parameters too. I think Refactor cannot help me in doing this, correct?
