How to alter user defined table types

sql-server alter user-defined-types
ganesh picture ganesh · Apr 25, 2015 · Viewed 25.3k times · Source

I have already tried to alter the user defined table types but it is not working with alter commend.

alter TYPE [dbo].[GriDDateTab] AS TABLE(
    [Application [varchar](50) NOT NULL,
    [LandDist] [char](2) NULL,
    [Land] [char](3) NULL,
    [LandVi] [char](4) NULL)

Answer

dmeglio picture dmeglio · Apr 25, 2015

You have to drop and recreate. That means if you have any references (eg stored procedures) using the type, that reference must be removed first.

Related questions

How to change column datatype in SQL database without losing data

I have SQL Server database and I just realized that I can change the type of one of the columns from int to bool. How can I do that without losing the data that is already entered into that table?

Read More
How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?

I would like to write a single SQL command to drop multiple columns from a single table in one ALTER TABLE statement. From MSDN's ALTER TABLE documentation... DROP { [CONSTRAINT] constraint_name | COLUMN column_name } Specifies that constraint_name or column_…

Read More
How to add new column in existing View in SQL-Server 2014 using Alter

I have created a view that is based on another view and a table. I want to add new column of type varchar. I did like below, But getting syntax error? I am new to SQL, So,could not understand …

Read More