[SQL2k5] Systemkatalog: Default-Werte?

[Phoenix]

Ach, verdammich. Hat sich erledigt. Ich hab grad mal raustracen lassen, was der Toad für SQL Server absetzt um das in Erfahrung zu bringen...

SQL-Code:

SELECT
  clmns.name AS [ColumnName],
  (
    select 
      case 
        when obj.parent_object_id <= 0
        then SCHEMA_NAME(obj.schema_id) + N'.' + obj.name
        else (select defs.definition
              from sys.default_constraints AS defs
              where defs.object_id = obj.object_id)
      end
    from sys.objects as obj
    where obj.object_id = clmns.default_object_id
  ) AS [Defaults]
FROM
  sys.tables AS tbl INNER JOIN sys.all_columns AS clmns ON clmns.object_id = tbl.object_id