create table dbo.[Finance_CityInfo]
([CityId] int identity(1,1)  not null  ,
[City] nvarchar(20) not null  ,
[CityPinyin] varchar(50) ,
[ShortIndb] varchar(20) ,
[ShortDomain] varchar(100) ,
[IsNorth] varchar(10) ,
[IsOpen] int default(‘1‘)  not null  ,
[CitySort] int default(‘1‘)  ,
primary key(CityId)
 ) 
  go