Function to see if Table exists in sql server

[Barno77]

Trying to build a function to see if table exists and if it doesn't then create that table!

Help would be greatly appreciated!

[ck9663]

Trying to build a function to see if table exists and if it doesn't then create that table!

Help would be greatly appreciated!

lots of ways...one of them:

if not exists (select 1 from sysobjects where name = @mytableparamet ername)
begin
create table ....

or you can also do a..

select * newtablename from blanktemplateta ble

or

set @sqlstring = ('create table ' + @mytableparamet ername + '.....')

exec (@sqlstring)

or

set @sqlstring = ('select * into ' + @mytableparamet ername + ' from blanktemplateta ble')
exec (@sqlstring)

end


this is obviously a pseudo-code...but i hope you get the idea...

-- CK

[Barno77]

lots of ways...one of them:

if not exists (select 1 from sysobjects where name = @mytableparamet ername)
begin
create table ....

or you can also do a..

select * newtablename from blanktemplateta ble

or

set @sqlstring = ('create table ' + @mytableparamet ername + '.....')

exec (@sqlstring)

or

set @sqlstring = ('select * into ' + @mytableparamet ername + ' from blanktemplateta ble')
exec (@sqlstring)

end


this is obviously a pseudo-code...but i hope you get the idea...

-- CK

Yes, I understand thank you!