Can I drop a table while leaving a view in tact?
I will recreate the tables with the same name after that...The correct sequence will be to drop the view first and then drop referenced
tables. [quote]Any view or stored procedure that references the dropped
table must be explicitly dropped by using the DROP VIEW or DROP PROCEDURE
statement.[/quote]. In practice I managed to drop referenced tables with
out
dropping the view first though I won't recommend it.
Cristian Lefter, SQL Server MVP
"AshVsAOD" <.> wrote in message
news:O4tsMD0OFHA.1176@.TK2MSFTNGP12.phx.gbl...
> Can I drop a table while leaving a view in tact?
> I will recreate the tables with the same name after that...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment