/*==============================================================*/
/* DBMS name:      Microsoft SQL Server 2005                    */
/* Created on:     18.06.2009 13:17:16                          */
/*==============================================================*/


if exists (select  1 
            from  sysobjects
           where  id = object_id('dbo.tmp_mdt_KVK')
            and   type = 'U')
   drop table dbo.tmp_mdt_KVK
go

execute sp_rename mdt_KVK, tmp_mdt_KVK
go

/*==============================================================*/
/* Table: mdt_KVK                                               */
/*==============================================================*/
create table dbo.mdt_KVK (
   ID_KVK               nvarchar( 3 )          collate SQL_Ukrainian_CP1251_CI_AS null,
   NAME_KVK             nvarchar( 128 )        collate SQL_Ukrainian_CP1251_CI_AS null
)
on "PRIMARY"
go

--WARNING: The following insert order will not restore columns: NAME_KVK
insert into dbo.mdt_KVK (ID_KVK)
select ID_KVK
from dbo.tmp_mdt_KVK
go