ti********@mind-infotech.com (T.S.Negi) wrote in message news:<a1**************************@posting.google. com>...
Hi there,
I have created a hash table. After using it, somehow the primary key
constraint of this hash table still exist in database. Which cause
error.
When I delete this constraint with Alter table Drop con....
It gives no table exist error.
Can anybody give any idea.
Thanks in Adv.,
T.S.Negi
I don't quite understand your issue - this works fine for me:
create table #t (col1 int not null)
alter table #t add constraint PK_t primary key (col1)
alter table #t drop constraint PK_t
drop table #t
It would be best to post your version of MSSQL, the exact error
messages you get, as well as some explanation of why you believe the
constraint exists but the table doesn't.
Simon