SQL Navigator

I am using SQL navigator and with this tool we are able to navigate to a stored procedure, right-click on it, choose 'Extract DDL', and this will give me a 'Create Stored Procedure...' script. This is very nice being able to do that.

However, I would really like to do this via a command line. For example, I would like to do this....

sqlnav.exe -ddl -sp MYPROC -o c:\myproc.sql

(above syntax has been made up for the purpose of the example)

SQL Navigator does not support this kind of thing. However, it does have a sort of tool called PL/Vision that would allow for things like this but these are objects that need to be loaded into the database, and I don't want extra things in my database.

[Quoted] Does any one know of a tool (or a way) that I can extract DDL scripts (of all kinds of objects including tables, views, stored proc, etc) from command line?

Thanks Received on Mon May 20 2002 - 07:23:48 CEST