Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User Defined

Status
Not open for further replies.

Trudye

Programmer
Sep 4, 2001
932
US
I have a question. How do I replace a Column User Defined Type?

When I used the Alter Table/Alter Column statement I received error msgs listing foreign keys and other columns that are dependant on my User Defined Col.

Other than droping the col (which let's face it is pretty drastic) how can I change it to a plain ole Type Int?

Thank much,
Trudye
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top