How to change a SQL Server View

2

I have some Views on SQl Server that have been implemented by other people, but they have not left any documentation and scripts, I believe it is possible to access to change and maintain them? But I do not know how to do that. Note: The view will be triggered by a user in Excel!

    
asked by anonymous 29.07.2015 / 16:02

1 answer

3

Use the example below as an example.

ALTER VIEW [dbo].[VIEW_EXEMPLO]
AS
    SELECT 1
GO

Or follow this step by step.

  • Right click on the view;
  • Click Script View as
  • Click ALTER TO
  • 29.07.2015 / 16:07