[dbo].[OidColumnMappingView]
CREATE VIEW OidColumnMappingView AS
SELECT ms.MibIdx, tbl.NameOfTable, td.TypeOfSaving, ms.OidIdxForMIB, cd.Name, ms.OID
FROM TablesDescription td join MibStructure ms
ON td.MibIdx = ms.MibIdx AND td.OidIdxForMIB = ms.OidIdxForMIB
JOIN ColumnDefinition cd ON cd.OrderOfColumn = td.OrderOfColumn
AND cd.OrderOfColumn = td.OrderOfColumn
AND cd.TableIdx = td.TableIdx
JOIN TableDefinition tbl
ON tbl.TableIdx = cd.TableIdx
GO
GRANT SELECT ON [dbo].[OidColumnMappingView] TO [uniadmin]
GO
