Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to change the base type of a UDT in Sql Server 2005?

Tags:

sql-server

sql-server-2005

user-defined-types

I have my type "x" of type varchar(50). How can I alter it to varchar(100)? It seems I can't!

like image 637
Ricibald Avatar asked Dec 08 '08 10:12

Ricibald

1 Answers

you can't. what you can do is

  • script all objects that contain the type using OBJECT_DEFINITION.
  • drop them.
  • recreate type with new length
  • recreate the objects.
like image 78
Mladen Prajdic Avatar answered Sep 17 '22 15:09

Mladen Prajdic
Sign in to Comment

Related questions

Table variable poor performance on insert in SQL Server Stored Procedure
Tools for Building an OCA (Occasionally Connected Application)
Looking for solution for database versioning
Replace with wildcard, in SQL
How to add more OR searches with CONTAINS Brings Query to Crawl?
Should I use 'Integrated Security=True' in a production environment?
Passing 'current' row to a function in SQL Server
Using stored procedures with Entity Framework 4 Code First CTP5
Can R produce on-the-fly graphs for website?
incorrect syntax near begin expecting EXTERNAL
Sql server's Constant scan - clarification?
Entity Framework 6 (code first) entity versioning and auditing
Use Option (Recompile) in an Inline Table Valued Function
SQL Server on Linux > Bulk Import error
Generating random values from uniform distribution with setting a seed in T-SQL
ASP.NET Core - Application not connecting to database after publishing
How to modify query in EF Core 2.0, before it goes to the SQL Server?
SQL Server connection errors when moving .net app to new server
SQL Server sys.databases log_reuse_wait question
How do you get output parameters from a stored procedure in Python?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!