3>
4> CREATE TYPE dbo.AccountNBR FROM char(14) NOT NULL
5> GO
1>
2>
3> SELECT OBJECT_NAME(p.object_id) Table_Name, p.name Parameter_Name
4> FROM sys.parameters p
5> INNER JOIN sys.types t ON
6> p.user_type_id = t.user_type_id
7> WHERE t.name = 'AccountNBR'
8> GO
Table_Name
Parameter_Name
------------------------------------------------------------------------------------------------------------------------
-------- ---------------------------------------------------------------------------------------------------------------
-----------------
1>
2> drop type dbo.AccountNBR
3> GO
1>