create table

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  April 9, 2003 at 3:13 pm

  #82048

  if object_id('hhhhhhh') is not null

  drop table hhhhhh

  go

  create table hhhhhhh

  (name varchar(50))

  If i run the above statement i am getting the following errors.

  can u explain why it's so

  Server: Msg 3701, Level 11, State 5, Line 2

  Cannot drop the table 'hhhhhh', because it does not exist in the system catalog.

  Server: Msg 2714, Level 16, State 6, Line 1

  There is already an object named 'hhhhhhh' in the database.

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  April 9, 2003 at 3:39 pm

  #453648

  you are dropping table hhhhhh and creating table hhhhhhh. You might try the same number of h's for both the create and the drop.

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP