KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Lets say I have this SQL statements: ALTER TABLE dbo.[tbl] ALTER COLUMN col1 varchar(300) ALTER TABLE dbo.[tbl] ALTER COLUMN col2 varchar(20) ALTER TABLE dbo.[tbl] ALTER COLUMN col3 varchar(20) ALTER TABLE dbo.[tbl] ALTER COLUMN col4 varchar(100) I have put these statements inside a file to be run one after the other. I also have a VIEW that is looking at dbo.[tbl]. I noticed that after running the 4 statements above the VIEW retains the old column lengths. So I added the following code to the end of the file: ALTER VIEW [dbo].[tbl] AS SELECT col1, col2, col3, col4 FROM dbo.[tbl] The error that I get is 'ALTER VIEW' must be the first statement in a query batch So my question is, what is the best way to ensure that my VIEW retains the new column lengths?
Tags (comma-separated)
Save Edits
Cancel