Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Field properties in views do not update after changes to base tables
1 view
Skip to first unread message
lhansen
Feb 22, 2008, 12:53:18 PM2/22/08
to
I'm using SQL Server 2005. I've created a view that pulls fields from
5 tables. One of the fields from one of the tables is called
'DivisionDesc'. At the time that the view was created, the datatype
of 'DivisionDesc' was nvarchar(30). Later, I changed the datatype of
the field in the base table to varchar(50). However, the view did not
automatically update with the new changes to the field. Is there a
way to have SSMS 'refresh' the datatypes and field sizes to reflect
any changes to the base tables?
5 tables. One of the fields from one of the tables is called
'DivisionDesc'. At the time that the view was created, the datatype
of 'DivisionDesc' was nvarchar(30). Later, I changed the datatype of
the field in the base table to varchar(50). However, the view did not
automatically update with the new changes to the field. Is there a
way to have SSMS 'refresh' the datatypes and field sizes to reflect
any changes to the base tables?
Knowledgy
Feb 28, 2008, 7:07:48 PM2/28/08
to
Is this ongoing or a one time occurrence. close ssms or hit f5. where in
SSMS are you viewing this? Server mgr or the workspace?
SSMS are you viewing this? Server mgr or the workspace?
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"lhansen" <lindsey...@fmc-na.com> wrote in message
news:c72d5dc9-42a6-4d5b...@k2g2000hse.googlegroups.com...
0 new messages