开发者

INFORMATION_SCHEMA.COLUMNS not updated

开发者 https://www.devze.com 2023-01-11 07:07 出处:网络
I notice this weird behavior where I change the column type from ntext to nvarchar(max) and in the INFORMATION_SCHEMA开发者_运维问答.COLUMNS the data_type remains ntext ...

I notice this weird behavior where I change the column type from ntext to nvarchar(max) and in the INFORMATION_SCHEMA开发者_运维问答.COLUMNS the data_type remains ntext ...

Is there something i must execute for the metadata to be refreshed?

I'm on sql server 2005


I don't get this behaviour on tables on SQL2005 (I just tested)

Is this for a view based on a table definition that has changed? If so

exec sp_refreshsqlmodule 'schema.ViewName'

should do it.

0

精彩评论

暂无评论...
验证码 换一张
取 消