The company's database management software, open database user rights do not have dbower, the default value and rules are lost when the data is changed. It is the software BUG. In fact, the intention of people is not imported data structure, but is the brigade. The data structure is generated with scripts.
It can be generated locally, it is simple and convenient, but still records it.
Create Table [IDCCM_F]. [DMTYPE] ([ID] [Bigint] Identity (1, 1) Not Null, [DMNAME] [VARCHAR] (50) Collate Chinese_PRC_CI_AS NULL, [DMCLA] [INT] NULL, [Websize] [ INT] null, [ostype] [tinyint] null, [scripttype] [varchar] (50) collate chinese_prc_ci_as null, [can] [tinyint] null, [ducgi] [tinyint] null, [canl] [tinyint] null, [ DBTYPE] [VARCHAR] (50) collate chinese_prc_ci_as null, [dbsize] [Tinyint] null, [canServlet] [tinyint] null, [canjavamail] [tinyint] null, [canjspgbk] [tinyint] NULL, [CanJDK] NULL, [CANPHP] [Tinyint] null, [canfso] [tinyint] null, [canmail] [tinyint] null, [canfp] [tinyint] null, [canstbook] [tinyint] NULL, [Cancount] NULL, [MAILSIZE] [INT] NULL, [PRICE] [INT] NULL, CONSTRAINT [PK_DMTYPE] Primary Key Clustered ([ID]) On [primary]) on [primary] GO
