无需放弃

改变你的观点。

试试这个。



更改视图view_name

as

更改您的查询



更改后执行上述操作。

可能对您有帮助。

no need to drop
alter your view.
try this.

alter view view_name
as
change your query

execute the above after change.
might this help you.

步骤1：使用sp_helptext查看视图的定义。



第2步：复制视图的定义并将其贴在T-SQL窗口中



步骤3：更改创建查看为Alter视图，然后在视图中添加新列，一旦完成更改执行查询窗口。然后更新视图的定义。

Step 1 : use sp_helptext to view the definition of the view.

step 2 : copy the definition of the view and paster it in the T-SQL window

step 3 : change the create view as Alter view and then add the new columns in the view, once the alteration in completed execute the query window. Then the definition of the view is updated.

什么是BISA1.EMPLOYEE_DETAILS_VIEW

仅使用EMPLOYEE_DETAILS_VIEW

what is BISA1.EMPLOYEE_DETAILS_VIEW
use EMPLOYEE_DETAILS_VIEW only