Dropping table conditionally

• mick L

  SSCommitted

  Points: 1526

  More actions

  May 19, 2008 at 4:58 am

  #187763

  Folks,

  Is it possible to drop a table based on some criteria e.g.

  drop table where......

  Thanks

  Mick

• Kevin-458339

  SSCrazy

  Points: 2717

  More actions

  May 19, 2008 at 5:02 am

  #817077

  Hi

  I would do it in the following manner:

  if (select count (*) from Tablename) > 8

  begin

  drop table tablename

  end

• mick L

  SSCommitted

  Points: 1526

  More actions

  May 19, 2008 at 5:11 am

  #817080

  thanks Kevin,

  So I guess it is not possible to apply conditionals directly to a drop statement then

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  May 19, 2008 at 7:22 am

  #817166

  [font="Verdana"]Yup, condition can not be placed on Drop statement.[/font]

  MH-09-AM-8694

• mick L

  SSCommitted

  Points: 1526

  More actions

  May 19, 2008 at 8:37 am

  #817204

  Thanks folks,

  I got there in the end.

  while EXISTS(SELECT * FROM sysobjects WHERE name like '%' + @table_Name + '%')

  BEGIN

  SELECT @found_name = [name] FROM sysobjects WHERE name like '%' + @table_Name + '%'

  SET @sqlCommand = 'DROP TABLE ' + @found_name

  EXEC (@sqlCommand)

  END