| Toad [message #275629] |
Mon, 22 October 2007 02:26  |
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
|
Senior Member |
|
|
Hi all,
In toad,i create a view like
create or replace view sample_view
as
select employee_id,department_id,last_name
from employees;
view created:
after that i check in view tab in schema browser.I select the scripts and it shows with view definition
create or replace view sample_view
(select employee_id,department_id,last_name)
as
select employee_id,department_id,last_name
from employees;
How to avoid the view definition In toad
Thank u
|
|
|
|
| Re: Toad [message #275648 is a reply to message #275629] |
Mon, 22 October 2007 03:42  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
As far as I can tell, you can't do that.
Why would you want to do it, anyway? The one who uses TOAD sees tables as well, so - what are you trying to hide?
What you might do is create a SYNONYM to a view which would conceal creation script. Of course, user who sees a synonym would have to be different from the one who created a view.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
