efwGetDDInfo

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