Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What happens to a view if an underlying table is dropped or renamed?

April 26, 2017dropped happens renamed Table underlying view

0

Posted

What happens to a view if an underlying table is dropped or renamed?

2 Answers

0

Posted

After a view has been created, it is possible to drop or alter a table or view to which the definition refers. To check a view definition for problems of this kind, use the CHECK TABLE statement. (See Section 12.5.2.3, “CHECK TABLE Syntax”.

0

Posted

After a view has been created, it is possible to drop or alter a table or view to which the definition refers. To check a view definition for problems of this kind, use the CHECK TABLE statement. (See Section 13.5.2.3, “CHECK TABLE Syntax”.