Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

Now see what parameters reference the AccountNBR data type

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>