To drop a field from a specific table, do the following:

  • Open Microsoft Sql Server Management Studio
  • Connect to the desired database and create a new query
  • Paste the following in the window:
    ALTER TABLE [TableName]
    DROP COLUMN [ColumnName]
  • Execute the query