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!

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

Changing user defined datatype definition

Status
Not open for further replies.
manutektips

manutektips

Programmer
Sep 8, 2003
11
GB
HI,
Is it possible to change the definition of a user defined datatype in SQL server 2000. I have defined a datatype called demail of varchar(50) and I want to change it to varchar(100). Please note that this datatype has been referrenced in many tables. Please suggest.
 
Sort by date Sort by votes
It appears that you can not. From what I'm reading and what I remember you can't modify a user defined data type. You have to drop and recreate the data type, which means removing it from all the tables, dropping it, adding it, and putting it back in all the tables.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(My very old site)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
400
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Determine sa Password When Signed On As Administrator User Thru Windows Authentication 1
Replies
2
Views
267
Auguy
Auguy
sanmikele2
  • Locked
  • Question
Creating a table and limiting datatype entry
Replies
6
Views
306
Olaf Doschke
Olaf Doschke
baran121
  • Locked
  • Question
sql user default language problem
Replies
7
Views
414
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top