list of data types

• Linda_web

  SSC Enthusiast

  Points: 179

  More actions

  May 1, 2009 at 3:19 pm

  #200073

  Hello,

  Is there a way to list all User Defined Data Types, also Roles with in the database

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  May 1, 2009 at 3:40 pm

  #987613

  select * from sys.types

  select * from sys.database_principals

  where type_desc = 'DATABASE_ROLE'

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  May 1, 2009 at 4:11 pm

  #987625

  http://msdn.microsoft.com/en-us/library/ms131120(SQL.90).aspx