use master gosp_dboption DBname,'select into',true //设置'select into' 允许拷贝goAlter table table_name drop column_name;