SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE dbo.efwGetDDInfo
@tablename char(30)
AS
SELECT tb.tablename, tb.abbr, tb.description, tb.termid, tb.uid, tb.reportoptions, tb.flags
FROM ddtables tb
WHERE tb.tablename = @tablename
SELECT dc.columnname, dc.description, dc.type, dc.length, dc.scale, dc.dimensions, dc.termid, dc.flags
FROM ddcolumns dc
WHERE dc.tablename = @tablename
ORDER BY dc.tablename, (type & 1048576), (dc.flags & 1), dc.seqnr, dc.columnname
SELECT di.indexname, di.type
FROM ddindexes di
WHERE di.tablename = @tablename
ORDER BY di.seqnr
SELECT dic.indexname, dic.columnname
FROM ddindexcolumns dic, ddindexes di
WHERE di.indexname = dic.indexname AND di.tablename = dic.tablename AND dic.tablename = @tablename
ORDER BY di.seqnr, dic.seqnr
SELECT dr.ReferenceName, dr.TargetTableName, dr.TargetIndexName, drc.ColumnName
FROM ddreferences dr, ddreferencecolumns drc
WHERE dr.tablename = @tablename AND drc.tablename = dr.tablename AND drc.referencename = dr.referencename
ORDER BY drc.tablename, drc.referencename, drc.seqnr
SELECT dt.fieldname, dt.databasechar, dt.displaychar, dt.description, dt.TermId, dt.Options
FROM ddtests dt
WHERE dt.tablename = @tablename
ORDER BY dt.fieldname, dt.seqnr
SELECT columnname, valutacolumn
FROM ddamountlink
WHERE tablename = @tablename
SELECT columnname, valutacolumn
FROM ddratelink
WHERE tablename = @tablename
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO