using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Management.Smo;

namespace DropTable
{
    class Program
    {
        static void Main(string[] args)
        {
            Server canopus5 = new Server("CANOPUS5");
            Table Test456 = canopus5.GetSmoObject(
                @"Server[@Name='CANOPUS5']
                /Database[@Name='scratch']
                /Table[@Name='Test456' and @Schema='dbo']")
                as Table;
            Test456.Drop();
        }
    }
}
