Question

Which view you will use to enter 5 new data items in the table *​

Answer 1

Answer:

If we head over to Object Explorer and refresh the Views folder, we should see that the name changed to vEmployees. There’s also a warning from SQL Server about changing any part of an object name that I’ve mentioned earlier:

Successfully executed script for renaming a view in SSMS showing the new name in Object Explorer

Now, let’s completely change the definition of the view by executing ;

GO

We could have just dropped the view and use the CREATE VIEW SQL statement to re-create it with the new definition, but we can’t break script and dependencies with this simple view, so it’s safe to just rename it using the stored procedure.