Member Avatar for deolalkar_pooja

Hi to all,
I created following table and its view.

[blue]create table employee(id integer, name varchar(20), age integer)

create view Vemployee as select id, name from employee.[/blue]

now I want to rename a view, so I wrote a query like

[blue]rename view Vemployee to Pemployee[/blue]

But, it shows error about 'raname' keyword.

what to do for renaming a view?


Thanks & regards,
Pooja.

  • 2 Contributors
  • 1 Reply
  • 77 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

You need to use ALTER VIEW.

Please read this for details.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.