以前做项目时

DROP TABLE table1

CREATE TABLE [table1] (
	[InitID] [int] IDENTITY (1, 1) NOT NULL ,
	[strStationID] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[strStationName] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[strApanage] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[strCity] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[strImportID] [int] NULL ,
	[ImportDate] [datetime] NULL ,
	CONSTRAINT [PK_table1] PRIMARY KEY  CLUSTERED 
	(
		[InitID]
	)  ON [PRIMARY] 
) ON [PRIMARY]