CREATE VIEW MibIndexView AS
SELECT mibIndex=md.MibIdx,mibDescription=md.Description
,indexOrder=coi.ComponentOfIndexOrder
,indexForMib=coi.OidIdxForMIB
,columnOrder=cd.OrderOfColumn
,tableName=tdf.NameOfTable
,columnName=cd.Name
FROM MIBDefinition md
,ComponentOfIndex coi
,TablesDescription tds
,TableDefinition tdf
,ColumnDefinition cd
WHERE md.MibIdx=tds.MibIdx
AND tds.TableIdx=cd.TableIdx
AND tds.OrderOfColumn=cd.OrderOfColumn
AND tds.TableIdx=tdf.TableIdx
AND tds.MibIdx=coi.MibIdx
AND tds.OidIdxForMIB=coi.OidIdxForMIB
GO
GRANT SELECT ON [dbo].[MibIndexView] TO [uniadmin]
GO
[dbo].[MibIndexView]