Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 problem in removing a constraint in a table

Author  Topic 

rammohan
Posting Yak Master

212 Posts

Posted - 2006-10-04 : 01:35:02
hi friends,
for my application i created a table which has a primary key column named num. this table contains this columns only.now i want to remove the column num. when i am tring to remove this column it is throwing the error:
"The object 'PK__Table_Null__023D5A04' is dependent on column 'num'."
so pls guide me on how to delete a primary key column from table.


thanx in advance,
rammohan

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-04 : 01:37:45
duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72964

Please do not cross post


KH

Go to Top of Page
   

- Advertisement -