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.
| Author |
Topic |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2006-10-04 : 01:35:42
|
| 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:36:47
|
DROP the constraint first before dropping the column num
KH |
 |
|
|
|
|
|
problem in removing a constraint in a table