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