DROP TABLE

• amksat

  Newbie

  Points: 7

  More actions

  October 25, 2005 at 8:53 pm

  #95610

  iM a newbie.

  I need a script that will allow me to drop a table BMUser.templist (BMUser as the dbo) if it exist regardless of what logon name I use (User is authorized as administrator).

   

  Can somebody help me ??

  Dem

   

   

   

   

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  October 25, 2005 at 10:43 pm

  #600005

  In order to drop a table in a database, the login must have one of these privileges

  1. Server level System Administrator role.

  2. Database db_owner role

  3. Database ddl_admin role

  4. Own the database - run sp_helpdb to see who owns the database.

  5. Be aliased to dbo but this is a depreciated feature.

  6. Own the table.

  If the login does not have one of these

  privileges, they cannot drop the table.

  The SQL statement should be:

  drop table BMUser.templist

  SQL = Scarcely Qualifies as a Language