How to alter user defined table types

Question

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 1

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.

Answer 2

The bad news is that you have to drop and re-create as SQL server does not (at least not up until 2012 support this.

The good news is that stored procedures and functions should pick up table type changes on the fly with no need to drop and re-create.