How to alter a User Defined Data Type?

Next>>         SQL Server tutorial  

SQL Server - How to alter a user-defined data type? - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

How to alter a user-defined data type?

To alter a User Defined Data Type, create a new User Defined Data Type and change all existing columns as required. Drop the existing User Defined Data Type and re create the new one.

SQL Server - How to alter a user-defined data type? - May 05, 2009 at 22:00 PM by Rajmeet Ghai

How to alter a user-defined data type?

The only way to alter a User Defined Data Type is to drop the existing and create a new one. Modifying the existing User Defined Data Type is prohibited as it may violate the validity of existing dependent data. ALTER ASSEMBLY command can also be used WITH UNCHECKED DATA clause.

SQL Server - How to alter a user-defined data type? - June 21, 2009 at 09:00 AM by Amit Satpute

A UDDT that is in use cannot be dropped.

However, the following steps can be followed to achieve it:

• Allocate a different data type for the fields which are using the UDDT.
• A data type of the UDDT should be allocated than an arbitrary one.
• Then drop the UDDT
• Create another and
• Allocate the new UDDT to the fields which had previous UDDT.

Next>>

Also read

What is the effect of DBCC CHECKDB and DBCC DBREINDEX on the Transaction log?

DBCC DBREINDEX is an offline operation is used to rebuild the indexes of a table dynamically.............

XML Data type implementation in SQL Server 2005

What is Untyped XML?
Provide examples for : Create a table with a untype XML column, Insert into an untyped XML data type column
What is typed XML?
The XML data type comes with five methods. Explain them
Differentiate between Untyped XML and Typed XML.
Explain with an example how to apply defaults constraint to an XML data type column.
You can add constraints to XML data type columns. Illustrate with an example.

Indexing XML data in SQL Server 2005

Explain the concepts of indexing XML data in SQL Server 2005.
Provide basic syntax for creating index on XML data type column.
What is content indexing/full text indexing?
Explain the reason to index XML data type column.
What are the guidelines to be adhered when creating a XML index?

Indexing XML data in SQL Server 2005

Explain the concepts of indexing XML data in SQL Server 2005.
Provide basic syntax for creating index on XML data type column.
What is content indexing/full text indexing?
Explain the reason to index XML data type column.
What are the guidelines to be adhered when creating a XML index?