Search code examples
sqlsql-serversql-server-2008-express

SQL Server: How to change name in a view?

I am using Visual Studio 2008 and SQL Server 2008 Express.

How can I change the name of the view? I can change tables' names, but I can't change the view name.

Any suggestion?

Solution

  • You can use the ALTER VIEW statement something like this :

    ALTER VIEW dbo.myView
AS
SELECT foo
FROM dbo.bar
WHERE widget = 'foo'
GO

    Reference on MSDN

    To rename a view, use sp_rename System Stored Procedure :

    EXEC sp_rename 'dbo.myView', 'myNewViewName'

    Note: don't include the schema name in the second string, or else you'll get a name like "dbo.dbo.myNewViewName".