Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2009-01-03 : 03:54:42
|
| Hi All,I have a problem in checking the existance of already created User Defined datatype. How to check whether the user defined Data type is already created.ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2009-01-03 : 06:23:58
|
| i got the answer -- Where SSN is User Defined Data Type nameIf Exists (select * from dbo.systypes Where Name = 'SSN') Print 'UDT Exists'Else Print 'UDT Not Exists'Solutions are easy. Understanding the problem, now, that's the hard part |
 |
|
|
|
|
|
Check Existance of User Defined Datatypes