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