在sqlserver中创建视图 [英] Creation of view in sqlserver

问题描述

我试图在sqlserver中创建视图。

Hi,

I ma trying to create the view in sqlserver.

Create view v_test
as
select * from Test

当我运行，它抛出错误，如消息15135，级别16，状态8，过程sp_addextendedproperty，第37行

对象无效。 ''dbo.v_test''不允许使用扩展属性，或者该对象不存在。

该语句已被终止。





任何人都可以帮助我吗？

When I run ,its throwing the error like Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37
Object is invalid. Extended properties are not permitted on ''dbo.v_test'', or the object does not exist.
The statement has been terminated.


Can anyoone help me?

推荐答案

您的问题有两种可能性



1.您可能无权创建视图



2.桌子可能不在您的桌子上



注意：您的语法是100％正确的。请验证我提到的上述两个步骤。

There are 2 possibilities for your problem

1. you may not have rights to create view

2. table may not be there in your table

Note: Your syntax is 100% correct.so verify the above 2 steps mention by me.

这篇关于在sqlserver中创建视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！