Hi All
In my script to a create table, how can check if the table exists? If the table exists, don't show any error message and don't try to create table

How come the following doesn't work?

I get the following error message
"There is already an object named 'test' in the database"



Please help

Not a sybase guy, but does your conditional work? I mean, without the CREATE TABLE statement, does it print "aaa" instead of "eee"?

After I create the "test" table, I tried applying the code.
The screen prints aaaaaaaaa. However, before it prints aaaaaaaa, it also shows the error message that "test" table already exists error message (but eeeeeee doesn't get printed)

Is it possible to modify the code, so that it doesn't print the table already exists error message?

Embed the create table statement in a exec() function:

exec ('create table...')

Regards,
Mariano

Hi tiger66,

This is not a runtime error, this is a compilation error.

Try this ..

1. Make sure 'test' table does not exists on database initially.

2. Create a proc for this

CREATE PROC sp_tigers
as
if (not exists (select 1 from sysobjects where name="test" and type="U"))
begin
print "eeeeeeeeeeeeee"
create table test
(
test char(1) not null,
)
end
else
print "aaaaaaaaaa"
go

3. Once compiled you should be able run it any times, without that error ..

cheers...
-samir
TechFruits.com