Microsoft SQL Skript Fehler.

Server: Nachr.-Nr. 170, Schweregrad 15, Status 1, Zeile 7
Zeile 7: Falsche Syntax in der Nähe von '('.
Server: Nachr.-Nr. 170, Schweregrad 15, Status 1, Zeile 18
Zeile 18: Falsche Syntax in der Nähe von '('.

Hier ist das folstände Skript.

USE [asd]
GO
/ Objekt: Table [dbo].[Supplier] Skriptdatum: 08/13/2006 11:57:49 /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Supplier] (
[ID] [int] IDENTITY(1,1) NOT NULL,
[SupplierNr] [int] NOT NULL,
CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Lot] (
[ID] [int] IDENTITY(1,1) NOT NULL,
[LotNr] [int] NOT NULL,
[FK_SupplierID] [int] NOT NULL,
[state] [int] NOT NULL CONSTRAINT [DF_Lot_state] DEFAULT ((0)),
CONSTRAINT [PK_Lot] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Lot] WITH CHECK ADD CONSTRAINT [FK_Lot_Supplier] FOREIGN KEY([FK_SupplierID])
REFERENCES [dbo].[Supplier] ([ID])
GO
ALTER TABLE [dbo].[Lot] CHECK CONSTRAINT [FK_Lot_Supplier]

Danke für Eure Hilfe.

CREATE TABLE [dbo].[Supplier] (
[ID] [int] IDENTITY(1,1) NOT NULL,
[SupplierNr] [int] NOT NULL,
CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED 
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE Supplier (
ID int IDENTITY(1,1) NOT NULL,
SupplierNr int NOT NULL,
CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED 
(
[ID] ASC
) WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]