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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 What table are User defined datatypes stored in?

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2010-10-07 : 12:51:49
I've got over a 100 user defined datatypes on a database that need to be removed. I want to write some dynamic SQL that will drop all of these datatypes.

Does anyone know which table datatype information is kept in? It's not in sysobjects.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-10-07 : 12:59:18
sys.types
Go to Top of Page
   

- Advertisement -