Re: SQL possible equivalent

On May 30, 8:10 am, DA Morgan <damor..._at_psoug.org> wrote:
> Jeff Kish wrote:
> > I have a script for mssql serverthat checks to see if a table exists... if
> > it does it drops it and recreates it.
>
> > I'm wondering how to do this using only sql if possible. I can figure it out
> > using pl/sql but I'm not sure of the correct approach (or even if it is
> > possible) using just sql.
>
> > I realize you can select from user_tab_cols like this:
> > select table_name from user_tab_columns where upper(table_name) = 'ASSET'
>
> > but how do I fit this into a sort of ifdef else sort of flow control in sql?
>
> > Can someone point me in the right direction? Do I need to somehow insert
> > pl/sql into the sql?
>
> > thanks
> > Jeff Kish
>
> The issue isn't how ... the issue is why. Oracle is NOT a Microsoft
> product rebranded. The concepts are different, the architecture is
> different, and kludges such as the one you are asking about used inSQL Serveronly because of its Ingres origins are possible but never
> done by people who learn the product.
>
> So the answer is you can do it using Native Dynamic SQL but you should
> instead learn Oracle unless you wish to write really really bad code.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

Ingres? Thats a new one, I suggest a little fact checking;

http://blogs.msdn.com/euanga/archive/2006/01/19/514479.aspx Received on Wed May 30 2007 - 18:47:15 CDT