Identifying Columns and Parameters that Use User-Defined Types : Create Type « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. Create Type

4>
5> CREATE TYPE dbo.AccountNBR FROM char(14) NOT NULL
6> GO
1>
2> CREATE TABLE dbo.MyCount
3> (ID int NOT NULL,
4>  AccountNBR AccountNBR)
5> GO
1>
2> SELECT OBJECT_NAME(c.object_id) Table_Name, c.name Column_Name
3> FROM sys.columns c
4> INNER JOIN sys.types t ON
5> c.user_type_id = t.user_type_id
6> WHERE t.name = 'AccountNBR'
7> GO
Table_Name
         Column_Name

------------------------------------------------------------------------------------------------------------------------
-------- ---------------------------------------------------------------------------------------------------------------
-----------------
MyCount
         AccountNBR

1>
2>
3> drop table dbo.MyCount
4> GO
1>
2> drop type dbo.AccountNBR
3> GO