CREATE TABLE [table1] (
	[col_char] [char] (10) COLLATE Japanese_CI_AS NULL ,
	[col_varchar] [varchar] (50) COLLATE Japanese_CI_AS NULL ,
	[col_smallint] [smallint] NULL ,
	[col_int] [int] NOT NULL ,
	[col_float] [float] NULL ,
	[col_real] [real] NULL ,
	[col_datetime] [datetime] NULL 
) ON [PRIMARY]

CREATE TABLE [table2] (
	[col1] [varchar] (50) COLLATE Japanese_CI_AS NULL ,
	[col2] [datetime] NULL 
) ON [PRIMARY]

ALTER TABLE [table1] ADD 
	CONSTRAINT [PK_table1] PRIMARY KEY  CLUSTERED 
	(
		[col_int]
	)  ON [PRIMARY] 

INSERT INTO table1 (col_char, col_varchar, col_smallint, col_int, col_float, col_real, col_datetime) VALUES ('abc', 'ABC', 100, 999, 1.5, 0.5, '2006/11/08 9:30:15')
