CBSE BOARD X, asked by devanshrana1, 1 month ago

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

Answers

Answered by lohitjinaga

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 ;

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.

Previous Question

Next Question

Similar questions

Biology, 16 days ago

assertion::menopause is a phase in women's life when ovulation and menstruation stops. reason::during this condition ovaries fail to respond or may be resistant of FSH...

Computer Science, 16 days ago

$\huge\mathcal\colorbox{pink}{{\color{b}\huge\purple{➳QuEsTiOn¿}}}$ LONG ANSWER TYPE QUESTIONS- 1. Explain any two limitations and characteristics of a computer. 2. How are computers used in the field of Research and Education? 3. How are computers used in the field of sports and military? 4. Explain the importance of computers in the government sector and law enforcement. 5.