CREATE DATABASE ProductDB
GO

USE ProductDB

CREATE TABLE [dbo].[Products] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[productname] [nvarchar] (64) NOT NULL ,
	[price] [money] NOT NULL ,
	[stock] [int] NOT NULL ,
	[comment] [nvarchar] (256) NOT NULL ,
	[detail] [nvarchar] (2048) NOT NULL ,
	[imgdata] [image] NULL ,
	[createdate] [datetime] NOT NULL ,
	[lastupdate] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Products] ADD 
	CONSTRAINT [PK_Products] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO