|
Posted by RS200Phil on 10/15/11 11:29
Hi all,
I've spent hours trying to find the error in the following SQL 2000
command:
ALTER TABLE [ClientList] ADD CONSTRAINT [PK_ClientList] PRIMARY KEY
CLUSTERED ([PhoneNo]) On [PRIMARY]
Every time I try to "Execute" this from my (VB5) ODBC connection I get:
Runtime error 3289;
Syntax error in CONSTRAINT clause
For the life of me I can see nothing wrong. I used Enterprise manager
to create this statement, and I can create the primary key fine from
there. The PhoneNo field does not allow NULLs.
Everything is service-packed up to date. I have tried using
[databasename].[dbo].[ClientList] and suchlike.
I've tried to find a relevant manual, but my SQL Server developers
guide suggests this should be ok and I can't see anything wrong in the
books online.
Can anybody please help?
TIA
Navigation:
[Reply to this message]
|