Where can I check the type of user definition table in SQL Server 2008 in SSMS? and how can I insert a new column into it?

Question

I need to add some more columns to the current current user-define table type in SQL Server 2008

But I did not see any type of table in a specific database in Tables .

Where exactly do I need to check and how can I change the design of an existing user-define table type in SQL Server 2008

I am using SQL SERVER 2008 and SSMS

Where can I find this table in SSMS ,

so that I can navigate and change the type of table.

thanks

to answer the previous question

Can someone help with sql alter type table add column syntax? how can i insert any new column ... since ALTER is not working .. it is disabled

Answer 1

Custom types cannot be changed after they are created, because changes can invalidate the data in tables or indexes. To change a type, you must either reset the type, or re-create it, or issue ALTER ASSEMBLY using the WITH UNCHECKED DATA clause. For more information, see ALTER ASSEMBLY (Transact-SQL).

Points to observe when using a custom table type

Values ​​1.Default are not allowed.

2. The primary key must be a persistent column.

3. Check constraint cannot be performed on unstable computed columns

4.Non cluster indexes are not allowed.

5. It cannot be changed. You need to reset and recreate it.