Script To Change User Defined Data Type

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Script To Change User Defined Data Type

Message

From

07/05/2007 15:56:09

Trevor Hendricks
Paradigm Technologies Corp.
Toronto, Ontario, Canada

All

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Script To Change User Defined Data Type

Environment versions

SQL Server:

SQL Server 2000

Miscellaneous

Thread ID:

01223196

Message ID:

01223196

Views:

Is there a way to change a user defined data type? I have a data type defined as nchar(10) that I want to make nchar(12). SQL Server complains that the data type is in use (which it is). I tried EM but it does not let me change the length either.

TIA
Trevor

Map

View

Click here to load this message in the networking platform