Project

General

Profile

Download (84.6 KB)

Data Services #1686 » 5)BridgeDetails,AbutmentDetails,PierDetails,SuperStructureDetails,BearingCondition,AbutmentCondition,ReturnWall_WingWall,PierBearingCondition&PierCondition This 9Tables Import Insert Changes.sql

Sindhuja Kadari, 05/02/2025 07:03 PM

 
delete TableColumnDef where TableNameDescription='BMS.BridgeDetails'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Latitude','BridgeDetails',1,'BMS','Latitude');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Longitude','BridgeDetails',2,'BMS','Longitude');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','BridgeCode','BridgeDetails',3,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SurveyYear','BridgeDetails',4,'BMS','SurveyYear');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','BrdgOvrTop','BridgeDetails',5,'BMS','BrdgOvrTop');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SignBrdDmgd','BridgeDetails',6,'BMS','SignBrdDmgd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Type1SpanNo','BridgeDetails',7,'BMS','Type1SpanNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','BrdgLen','BridgeDetails',8,'BMS','BrdgLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','DesignLoading','BridgeDetails',9,'BMS','DesignLoading');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Repairsdonepriortoinventory','BridgeDetails',10,'BMS','Repairsdonepriortoinventory');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','ApprchSlabPrvd','BridgeDetails',11,'BMS','ApprchSlabPrvd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','ApprchLength','BridgeDetails',12,'BMS','ApprchLength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','ApprchRoadWidth','BridgeDetails',13,'BMS','ApprchRoadWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','WearingCoatType','BridgeDetails',14,'BMS','WearingCoatType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','OverallDeckwidth','BridgeDetails',15,'BMS','OverallDeckwidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Carriagewaywidth','BridgeDetails',16,'BMS','Carriagewaywidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','DrngSpoutsPrvd','BridgeDetails',17,'BMS','DrngSpoutsPrvd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','NoofSpoutsPerSpan','BridgeDetails',18,'BMS','NoofSpoutsPerSpan');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','RailWidth','BridgeDetails',19,'BMS','RailWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','RailHeight','BridgeDetails',20,'BMS','RailHeight');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','CCRailing','BridgeDetails',21,'BMS','CCRailing');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','FootpathonBridge','BridgeDetails',22,'BMS','FootpathonBridge');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','FootPathWidthLHS','BridgeDetails',23,'BMS','FootPathWidthLHS');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','FootPathWidthRHS','BridgeDetails',24,'BMS','FootPathWidthRHS');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','KerbonBridge','BridgeDetails',25,'BMS','KerbonBridge');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','KerbWidthLHS','BridgeDetails',26,'BMS','KerbWidthLHS');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','KerbWidthRHS','BridgeDetails',27,'BMS','KerbWidthRHS');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','ExpnJointExists','BridgeDetails',28,'BMS','ExpnJointExists');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','ExpnJointType','BridgeDetails',29,'BMS','ExpnJointType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','DateofInspection','BridgeDetails',30,'BMS','DateofInspection');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','RoadCode','BridgeDetails',31,'BMS','RoadCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Direction','BridgeDetails',32,'BMS','Direction');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Chainage','BridgeDetails',33,'BMS','Chainage');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','CnstrctYear','BridgeDetails',34,'BMS','CnstrctYear');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','BrdgType','BridgeDetails',35,'BMS','BrdgType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','BrdgFunc','BridgeDetails',36,'BMS','BrdgFunc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','RiverName','BridgeDetails',37,'BMS','RiverName');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','NearByPlace','BridgeDetails',38,'BMS','NearByPlace');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','ContractorFirm','BridgeDetails',39,'BMS','ContractorFirm');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SupervisedConsultant','BridgeDetails',40,'BMS','SupervisedConsultant');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','DesignConsultant','BridgeDetails',41,'BMS','DesignConsultant');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','StreamCategory','BridgeDetails',42,'BMS','StreamCategory');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SkewAngle','BridgeDetails',43,'BMS','SkewAngle');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','BrdgGradient','BridgeDetails',44,'BMS','BrdgGradient');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','HFLBedLevel','BridgeDetails',45,'BMS','HFLBedLevel');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Clearverticaldistance','BridgeDetails',46,'BMS','Clearverticaldistance');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SuperStrctType','BridgeDetails',47,'BMS','SuperStrctType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','FootpathType','BridgeDetails',48,'BMS','FootpathType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','AbutmentwallRailingtype','BridgeDetails',49,'BMS','AbutmentwallRailingtype');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','OrentofDrngPipe','BridgeDetails',50,'BMS','OrentofDrngPipe');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','DrngePipeMaterial','BridgeDetails',51,'BMS','DrngePipeMaterial');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','LocofSrvc','BridgeDetails',52,'BMS','LocofSrvc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Strctnum','BridgeDetails',53,'BMS','Strctnum');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','MainSuperStrctType','BridgeDetails',54,'BMS','MainSuperStrctType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Type2SpanNo','BridgeDetails',55,'BMS','Type2SpanNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Type2SpanLength','BridgeDetails',56,'BMS','Type2SpanLength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Type3SpanNo','BridgeDetails',57,'BMS','Type3SpanNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Type3SpanLength','BridgeDetails',58,'BMS','Type3SpanLength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','TotalSpanNo','BridgeDetails',59,'BMS','TotalSpanNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SkewValue','BridgeDetails',60,'BMS','SkewValue');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','PresentLoading','BridgeDetails',61,'BMS','PresentLoading');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SideSlopePitch','BridgeDetails',62,'BMS','SideSlopePitch');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','FloorPrtctPrvd','BridgeDetails',63,'BMS','FloorPrtctPrvd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SrvcLineCrosBrdg','BridgeDetails',64,'BMS','SrvcLineCrosBrdg');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','FloorPrtctType','BridgeDetails',65,'BMS','FloorPrtctType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','NoSrvcDuctsFootpath','BridgeDetails',66,'BMS','NoSrvcDuctsFootpath');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','ExpnJointsNo','BridgeDetails',67,'BMS','ExpnJointsNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','NoofSrvcLine','BridgeDetails',68,'BMS','NoofSrvcLine');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SrvcLineType','BridgeDetails',69,'BMS','SrvcLineType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Type1SpanLength','BridgeDetails',70,'BMS','Type1SpanLength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','WaterWay','BridgeDetails',71,'BMS','WaterWay');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','BedMtrlType','BridgeDetails',72,'BMS','BedMtrlType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SrvcLinePresentOn','BridgeDetails',73,'BMS','SrvcLinePresentOn');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SideSlopePitchType','BridgeDetails',74,'BMS','SideSlopePitchType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','PipesDiameter','BridgeDetails',75,'BMS','PipesDiameter');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SpacingBtwnPipes','BridgeDetails',76,'BMS','SpacingBtwnPipes');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','HeadwallLength','BridgeDetails',77,'BMS','HeadwallLength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Crossingtherivertype','BridgeDetails',78,'BMS','Crossingtherivertype');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','PipeMtrl','BridgeDetails',79,'BMS','PipeMtrl');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','PipesCount','BridgeDetails',80,'BMS','PipesCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','CushionAbovePipe','BridgeDetails',81,'BMS','CushionAbovePipe');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','Remarks','BridgeDetails',82,'BMS','Remarks');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SpanArrgmnt','BridgeDetails',83,'BMS','SpanArrgmnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','BrdgCatg','BridgeDetails',84,'BMS','BrdgCatg');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','PrtctWrksCondSev','BridgeDetails',85,'BMS','PrtctWrksCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','PrtctWrksCondExt','BridgeDetails',86,'BMS','PrtctWrksCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','SideSlpPitchArea','BridgeDetails',87,'BMS','SideSlpPitchArea');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','FloorPrtctArea','BridgeDetails',88,'BMS','FloorPrtctArea');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BridgeDetails','BMS.BridgeDetails','WtrwayBlockage','BridgeDetails',89,'BMS','WtrwayBlockage');
GO
delete TableColumnDef where TableNameDescription='BMS.AbutmentDetails'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','BridgeCode','AbutmentDetails',1,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','DateofInspection','AbutmentDetails',2,'BMS','DateofInspection');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','AbtmntNo','AbutmentDetails',3,'BMS','AbtmntNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','AbtmntType','AbutmentDetails',4,'BMS','AbtmntType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','AbtmntMtrl','AbutmentDetails',5,'BMS','AbtmntMtrl');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','ClmnsCount','AbutmentDetails',6,'BMS','ClmnsCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','ClmnsThcktop','AbutmentDetails',7,'BMS','ClmnsThcktop');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','ClmnsThckbttm','AbutmentDetails',8,'BMS','ClmnsThckbttm');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','ClmnsHeight','AbutmentDetails',9,'BMS','ClmnsHeight');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','ClmnsLenatTop','AbutmentDetails',10,'BMS','ClmnsLenatTop');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','ClmnsLenatBttm','AbutmentDetails',11,'BMS','ClmnsLenatBttm');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','CapLength','AbutmentDetails',12,'BMS','CapLength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','CapWidth','AbutmentDetails',13,'BMS','CapWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','capThick','AbutmentDetails',14,'BMS','capThick');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','DrtWallLength','AbutmentDetails',15,'BMS','DrtWallLength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','DrtWallThck','AbutmentDetails',16,'BMS','DrtWallThck');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','DrtWallHeight','AbutmentDetails',17,'BMS','DrtWallHeight');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','WeepHolesPrvd','AbutmentDetails',18,'BMS','WeepHolesPrvd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','WeepHolesCount','AbutmentDetails',19,'BMS','WeepHolesCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','RetningWallType','AbutmentDetails',20,'BMS','RetningWallType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','RetningWallMtrl','AbutmentDetails',21,'BMS','RetningWallMtrl');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','LengthonEachSide','AbutmentDetails',22,'BMS','LengthonEachSide');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','BearingsPrvd','AbutmentDetails',23,'BMS','BearingsPrvd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','BearingsVisible','AbutmentDetails',24,'BMS','BearingsVisible');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','AbtmntBearingsType','AbutmentDetails',25,'BMS','AbtmntBearingsType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','BearingsCount','AbutmentDetails',26,'BMS','BearingsCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','SmcRstnrPrvd','AbutmentDetails',27,'BMS','SmcRstnrPrvd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','SmcRstnrMtrl','AbutmentDetails',28,'BMS','SmcRstnrMtrl');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','SmcRstnrLoc','AbutmentDetails',29,'BMS','SmcRstnrLoc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','FndtionType','AbutmentDetails',30,'BMS','FndtionType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','RaftWidth','AbutmentDetails',31,'BMS','RaftWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','Raftlength','AbutmentDetails',32,'BMS','Raftlength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','NoofPiles','AbutmentDetails',33,'BMS','NoofPiles');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','WlPlDiameter','AbutmentDetails',34,'BMS','WlPlDiameter');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','WellDepth','AbutmentDetails',35,'BMS','WellDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','PileWidth','AbutmentDetails',36,'BMS','PileWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','WellType','AbutmentDetails',37,'BMS','WellType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','FndtionMtrlType','AbutmentDetails',38,'BMS','FndtionMtrlType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentDetails','BMS.AbutmentDetails','Remarks','AbutmentDetails',39,'BMS','Remarks');
GO
delete TableColumnDef where TableNameDescription='BMS.PierDetails'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','BridgeCode','PierDetails',1,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','DateofInspection','PierDetails',2,'BMS','DateofInspection');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','PierNo','PierDetails',3,'BMS','PierNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','CapWidth','PierDetails',4,'BMS','CapWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','UniformCapHeight','PierDetails',5,'BMS','UniformCapHeight');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','TaperedCapHeight','PierDetails',6,'BMS','TaperedCapHeight');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','CapLenTop','PierDetails',7,'BMS','CapLenTop');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','CapLenBttm','PierDetails',8,'BMS','CapLenBttm');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','PierType','PierDetails',9,'BMS','PierType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','PierMaterial','PierDetails',10,'BMS','PierMaterial');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','PierTopLen','PierDetails',11,'BMS','PierTopLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','PierBttmLen','PierDetails',12,'BMS','PierBttmLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','PierHeight','PierDetails',13,'BMS','PierHeight');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','ClmnsCount','PierDetails',14,'BMS','ClmnsCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','ClmnsThcktop','PierDetails',15,'BMS','ClmnsThcktop');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','ClmnsThckbttm','PierDetails',16,'BMS','ClmnsThckbttm');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','CutEaseWaterType','PierDetails',17,'BMS','CutEaseWaterType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','BearingsPrvd','PierDetails',18,'BMS','BearingsPrvd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','BearingsVisible','PierDetails',19,'BMS','BearingsVisible');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','PierBearingsType','PierDetails',20,'BMS','PierBearingsType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','BearingsCount','PierDetails',21,'BMS','BearingsCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','SmcRstnrPrvd','PierDetails',22,'BMS','SmcRstnrPrvd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','SmcRstnrMtrl','PierDetails',23,'BMS','SmcRstnrMtrl');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','SmcRstnrLoc','PierDetails',24,'BMS','SmcRstnrLoc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','PileWidth','PierDetails',25,'BMS','PileWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','WellFundtionType','PierDetails',26,'BMS','WellFundtionType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','FndtionMtrlType','PierDetails',27,'BMS','FndtionMtrlType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','Remarks','PierDetails',28,'BMS','Remarks');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','FndtionType','PierDetails',29,'BMS','FndtionType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','RaftWidth','PierDetails',30,'BMS','RaftWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','Raftlength','PierDetails',31,'BMS','Raftlength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','NoofPiles','PierDetails',32,'BMS','NoofPiles');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','WlPlDiameter','PierDetails',33,'BMS','WlPlDiameter');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierDetails','BMS.PierDetails','WellDepth','PierDetails',34,'BMS','WellDepth');
GO
delete TableColumnDef where TableNameDescription='BMS.SuperStructureDetails'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','BridgeCode','SuperStructureDetails',1,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','DateofInspection','SuperStructureDetails',2,'BMS','DateofInspection');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','SpanNo','SuperStructureDetails',3,'BMS','SpanNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','SpanLen','SuperStructureDetails',4,'BMS','SpanLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','SpanTopWidth','SuperStructureDetails',5,'BMS','SpanTopWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','SpanBttmWidth','SuperStructureDetails',6,'BMS','SpanBttmWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','SpanThickness','SuperStructureDetails',7,'BMS','SpanThickness');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','LongGirderCount','SuperStructureDetails',8,'BMS','LongGirderCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','LongGirderSpacing','SuperStructureDetails',9,'BMS','LongGirderSpacing');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','LongGirderDepth','SuperStructureDetails',10,'BMS','LongGirderDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','LongGirderWidth','SuperStructureDetails',11,'BMS','LongGirderWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','CrossGirdersCount','SuperStructureDetails',12,'BMS','CrossGirdersCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','CrossGirderDepth','SuperStructureDetails',13,'BMS','CrossGirderDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','CrossGirderThick','SuperStructureDetails',14,'BMS','CrossGirderThick');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','MonolithicCrossGirder','SuperStructureDetails',15,'BMS','MonolithicCrossGirder');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','MainSpanLen','SuperStructureDetails',16,'BMS','MainSpanLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','CantileverSpanLen','SuperStructureDetails',17,'BMS','CantileverSpanLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','SuspendedSpanLen','SuperStructureDetails',18,'BMS','SuspendedSpanLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','PylonCableCount','SuperStructureDetails',19,'BMS','PylonCableCount');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','ArchCountinSpan','SuperStructureDetails',20,'BMS','ArchCountinSpan');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','ArchSpace','SuperStructureDetails',21,'BMS','ArchSpace');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','ArchDepth','SuperStructureDetails',22,'BMS','ArchDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','ArchSupportThickness','SuperStructureDetails',23,'BMS','ArchSupportThickness');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','ArchCrownThickness','SuperStructureDetails',24,'BMS','ArchCrownThickness');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('SuperStructureDetails','BMS.SuperStructureDetails','Remarks','SuperStructureDetails',25,'BMS','Remarks');
GO
delete TableColumnDef where TableNameDescription='BMS.BearingCondition'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','BridgeCode','BearingCondition',1,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','SurveyYear','BearingCondition',2,'BMS','SurveyYear');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','AbtmntNo','BearingCondition',3,'BMS','AbtmntNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','CmprsBulgSides','BearingCondition',4,'BMS','CmprsBulgSides');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','SurfaceCrck','BearingCondition',5,'BMS','SurfaceCrck');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','Rdlcrck','BearingCondition',6,'BMS','Rdlcrck');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','ExsShrDfrmt','BearingCondition',7,'BMS','ExsShrDfrmt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','DfrmtBearingShp','BearingCondition',8,'BMS','DfrmtBearingShp');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','AnchorBoltsDamaged','BearingCondition',9,'BMS','AnchorBoltsDamaged');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','bearingFreeMove','BearingCondition',10,'BMS','bearingFreeMove');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','FrgnMtrlExists','BearingCondition',11,'BMS','FrgnMtrlExists');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','RlrsRckrsPropPositn','BearingCondition',12,'BMS','RlrsRckrsPropPositn');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','NutLooseLocCnt','BearingCondition',13,'BMS','NutLooseLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','BearingInspectedNtMsrd','BearingCondition',14,'BMS','BearingInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','BearingCondSev','BearingCondition',15,'BMS','BearingCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','BearingCondExt','BearingCondition',16,'BMS','BearingCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','CrckInBearingsPdstl','BearingCondition',17,'BMS','CrckInBearingsPdstl');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','CrckCnt','BearingCondition',18,'BMS','CrckCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','CrckType','BearingCondition',19,'BMS','CrckType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','CrckWidth','BearingCondition',20,'BMS','CrckWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','PdstlsInspectedNtMsrd','BearingCondition',21,'BMS','PdstlsInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','PdstlsCondSev','BearingCondition',22,'BMS','PdstlsCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','PdstlsCondExt','BearingCondition',23,'BMS','PdstlsCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','CrcksInSmrstr','BearingCondition',24,'BMS','CrcksInSmrstr');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','SplDlmnCncrt','BearingCondition',25,'BMS','SplDlmnCncrt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','ExpCrrdReinfrcmnt','BearingCondition',26,'BMS','ExpCrrdReinfrcmnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','Anypartbroken','BearingCondition',27,'BMS','Anypartbroken');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','DisldgmntBcklng','BearingCondition',28,'BMS','DisldgmntBcklng');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','PaintDamage','BearingCondition',29,'BMS','PaintDamage');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','LoosenutsBoltsCrackedweldetc','BearingCondition',30,'BMS','LoosenutsBoltsCrackedweldetc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','SmRstrInspectedNtMsrd','BearingCondition',31,'BMS','SmRstrInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','SmRstrCondSev','BearingCondition',32,'BMS','SmRstrCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','SmRstrCondExt','BearingCondition',33,'BMS','SmRstrCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('BearingCondition','BMS.BearingCondition','Remarks','BearingCondition',34,'BMS','Remarks');
GO
delete TableColumnDef where TableNameDescription='BMS.AbutmentCondition'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','BridgeCode','AbutmentCondition',1,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SurveyYear','AbutmentCondition',2,'BMS','SurveyYear');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','AbutmentNo','AbutmentCondition',3,'BMS','AbutmentNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DirtWallDfrmt','AbutmentCondition',4,'BMS','DirtWallDfrmt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DirtWallCrcks','AbutmentCondition',5,'BMS','DirtWallCrcks');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DirtWallRdlcrck','AbutmentCondition',6,'BMS','DirtWallRdlcrck');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DirtWallExsShrDfrmt','AbutmentCondition',7,'BMS','DirtWallExsShrDfrmt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DirtWallInspectedNtMsrd','AbutmentCondition',8,'BMS','DirtWallInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DirtWallCondSev','AbutmentCondition',9,'BMS','DirtWallCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DirtWallCondExt','AbutmentCondition',10,'BMS','DirtWallCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrIsCracked','AbutmentCondition',11,'BMS','SubStrIsCracked');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrCrckLen','AbutmentCondition',12,'BMS','SubStrCrckLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrCrckWidth','AbutmentCondition',13,'BMS','SubStrCrckWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrCrckLoc','AbutmentCondition',14,'BMS','SubStrCrckLoc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrCrckNature','AbutmentCondition',15,'BMS','SubStrCrckNature');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrCrckPercent','AbutmentCondition',16,'BMS','SubStrCrckPercent');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrWpHolesBlocked','AbutmentCondition',17,'BMS','SubStrWpHolesBlocked');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrIsSpalling','AbutmentCondition',18,'BMS','SubStrIsSpalling');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrSpallingArea','AbutmentCondition',19,'BMS','SubStrSpallingArea');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrSpallingLocCnt','AbutmentCondition',20,'BMS','SubStrSpallingLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrIsRCCExposed','AbutmentCondition',21,'BMS','SubStrIsRCCExposed');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrRCCExposedDtls','AbutmentCondition',22,'BMS','SubStrRCCExposedDtls');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrLseJntCnt','AbutmentCondition',23,'BMS','SubStrLseJntCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrMtrlLsJntCnt','AbutmentCondition',24,'BMS','SubStrMtrlLsJntCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrLseStonesLocCnt','AbutmentCondition',25,'BMS','SubStrLseStonesLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrPlstrCond','AbutmentCondition',26,'BMS','SubStrPlstrCond');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrSpiltLocCnt','AbutmentCondition',27,'BMS','SubStrSpiltLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrVegJnts','AbutmentCondition',28,'BMS','SubStrVegJnts');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubStrInspectedNtMsrd','AbutmentCondition',29,'BMS','SubStrInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubstrCondSev','AbutmentCondition',30,'BMS','SubstrCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','SubstrCondExt','AbutmentCondition',31,'BMS','SubstrCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionIsScoursObsv','AbutmentCondition',32,'BMS','FndtionIsScoursObsv');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionScoursDepth','AbutmentCondition',33,'BMS','FndtionScoursDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionIsStlmnt','AbutmentCondition',34,'BMS','FndtionIsStlmnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionStlmntDepth','AbutmentCondition',35,'BMS','FndtionStlmntDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionIsRiverBedDmgd','AbutmentCondition',36,'BMS','FndtionIsRiverBedDmgd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionflotingbodiesImpct','AbutmentCondition',37,'BMS','FndtionflotingbodiesImpct');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionInspectedNtMsrd','AbutmentCondition',38,'BMS','FndtionInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionCondSev','AbutmentCondition',39,'BMS','FndtionCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','FndtionCondExt','AbutmentCondition',40,'BMS','FndtionCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DSDmgedExpsionJnt','AbutmentCondition',41,'BMS','DSDmgedExpsionJnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DSExpsionJntCondSev','AbutmentCondition',42,'BMS','DSExpsionJntCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DSExpsionJntCondExt','AbutmentCondition',43,'BMS','DSExpsionJntCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DSDmgedApprchSlab','AbutmentCondition',44,'BMS','DSDmgedApprchSlab');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DSApprchSlabCondSev','AbutmentCondition',45,'BMS','DSApprchSlabCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','DSApprchSlabCondExt','AbutmentCondition',46,'BMS','DSApprchSlabCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('AbutmentCondition','BMS.AbutmentCondition','Remarks','AbutmentCondition',47,'BMS','Remarks');
GO
delete TableColumnDef where TableNameDescription='BMS.PierCondition'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','BridgeCode','PierCondition',1,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SurveyYear','PierCondition',2,'BMS','SurveyYear');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierNo','PierCondition',3,'BMS','PierNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','RCCCracking','PierCondition',4,'BMS','RCCCracking');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapCrcklength','PierCondition',5,'BMS','PierCapCrcklength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapCrckWidth','PierCondition',6,'BMS','PierCapCrckWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapCrckPercent','PierCondition',7,'BMS','PierCapCrckPercent');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapIsSpalling','PierCondition',8,'BMS','PierCapIsSpalling');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapSpallingArea','PierCondition',9,'BMS','PierCapSpallingArea');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapSpallingAvgDepth','PierCondition',10,'BMS','PierCapSpallingAvgDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapIsRCCExposed','PierCondition',11,'BMS','PierCapIsRCCExposed');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapInspectedNtMsrd','PierCondition',12,'BMS','PierCapInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapCondSev','PierCondition',13,'BMS','PierCapCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','PierCapCondExt','PierCondition',14,'BMS','PierCapCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrIsCracked','PierCondition',15,'BMS','SubStrIsCracked');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrCrckLength','PierCondition',16,'BMS','SubStrCrckLength');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrCrckWidth','PierCondition',17,'BMS','SubStrCrckWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrCrckNature','PierCondition',18,'BMS','SubStrCrckNature');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrCrckLoc','PierCondition',19,'BMS','SubStrCrckLoc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrCrckPercent','PierCondition',20,'BMS','SubStrCrckPercent');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrIsSpalling','PierCondition',21,'BMS','SubStrIsSpalling');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrSpallingArea','PierCondition',22,'BMS','SubStrSpallingArea');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrSpallingLocCnt','PierCondition',23,'BMS','SubStrSpallingLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrIsRCCExposed','PierCondition',24,'BMS','SubStrIsRCCExposed');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrRCCExposedDtls','PierCondition',25,'BMS','SubStrRCCExposedDtls');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrLseJntCnt','PierCondition',26,'BMS','SubStrLseJntCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrMtrlLsJntCnt','PierCondition',27,'BMS','SubStrMtrlLsJntCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrLseStonesLocCnt','PierCondition',28,'BMS','SubStrLseStonesLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrPlstrCond','PierCondition',29,'BMS','SubStrPlstrCond');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrSpiltLocCnt','PierCondition',30,'BMS','SubStrSpiltLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrVegJnts','PierCondition',31,'BMS','SubStrVegJnts');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrInspectedNtMsrd','PierCondition',32,'BMS','SubStrInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrCondSev','PierCondition',33,'BMS','SubStrCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','SubStrCondExt','PierCondition',34,'BMS','SubStrCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionIsScoursObsv','PierCondition',35,'BMS','FndtionIsScoursObsv');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionScoursDepth','PierCondition',36,'BMS','FndtionScoursDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionIsStlmnt','PierCondition',37,'BMS','FndtionIsStlmnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionStlmntDepth','PierCondition',38,'BMS','FndtionStlmntDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionIsRiverBedDmgd','PierCondition',39,'BMS','FndtionIsRiverBedDmgd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionflotingbodiesImpct','PierCondition',40,'BMS','FndtionflotingbodiesImpct');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionInspectedNtMsrd','PierCondition',41,'BMS','FndtionInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionCondSev','PierCondition',42,'BMS','FndtionCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','FndtionCondExt','PierCondition',43,'BMS','FndtionCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','DSDmgedExpsionJnt','PierCondition',44,'BMS','DSDmgedExpsionJnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','DSExpsionJntCondSev','PierCondition',45,'BMS','DSExpsionJntCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','DSExpsionJntCondExt','PierCondition',46,'BMS','DSExpsionJntCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','DSDmgedApprchSlab','PierCondition',47,'BMS','DSDmgedApprchSlab');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','DSApprchSlabCondSev','PierCondition',48,'BMS','DSApprchSlabCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','DSApprchSlabCondExt','PierCondition',49,'BMS','DSApprchSlabCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierCondition','BMS.PierCondition','Remarks','PierCondition',50,'BMS','Remarks');
GO
delete TableColumnDef where TableNameDescription='BMS.PierBearingCondition'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','BridgeCode','PierBearingCondition',1,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','SurveyYear','PierBearingCondition',2,'BMS','SurveyYear');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','PierNo','PierBearingCondition',3,'BMS','PierNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','CmprsBulgSides','PierBearingCondition',4,'BMS','CmprsBulgSides');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','SurfaceCrck','PierBearingCondition',5,'BMS','SurfaceCrck');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','Rdlcrck','PierBearingCondition',6,'BMS','Rdlcrck');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','ExsShrDfrmt','PierBearingCondition',7,'BMS','ExsShrDfrmt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','DfrmtBearingShp','PierBearingCondition',8,'BMS','DfrmtBearingShp');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','AnchorBoltsDamaged','PierBearingCondition',9,'BMS','AnchorBoltsDamaged');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','bearingFreeMove','PierBearingCondition',10,'BMS','bearingFreeMove');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','FrgnMtrlExists','PierBearingCondition',11,'BMS','FrgnMtrlExists');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','RlrsRckrsPropPositn','PierBearingCondition',12,'BMS','RlrsRckrsPropPositn');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','NutLooseLocCnt','PierBearingCondition',13,'BMS','NutLooseLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','BearingInspectedNtMsrd','PierBearingCondition',14,'BMS','BearingInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','BearingCondSev','PierBearingCondition',15,'BMS','BearingCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','BearingCondExt','PierBearingCondition',16,'BMS','BearingCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','CrckInBearingsPdstl','PierBearingCondition',17,'BMS','CrckInBearingsPdstl');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','CrckCnt','PierBearingCondition',18,'BMS','CrckCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','CrckType','PierBearingCondition',19,'BMS','CrckType');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','CrckWidth','PierBearingCondition',20,'BMS','CrckWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','PdstlsInspectedNtMsrd','PierBearingCondition',21,'BMS','PdstlsInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','PdstlsCondSev','PierBearingCondition',22,'BMS','PdstlsCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','PdstlsCondExt','PierBearingCondition',23,'BMS','PdstlsCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','CrcksInSmrstr','PierBearingCondition',24,'BMS','CrcksInSmrstr');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','SplDlmnCncrt','PierBearingCondition',25,'BMS','SplDlmnCncrt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','ExpCrrdReinfrcmnt','PierBearingCondition',26,'BMS','ExpCrrdReinfrcmnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','Anypartbroken','PierBearingCondition',27,'BMS','Anypartbroken');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','DisldgmntBcklng','PierBearingCondition',28,'BMS','DisldgmntBcklng');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','PaintDamage','PierBearingCondition',29,'BMS','PaintDamage');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','LoosenutsBoltsCrackedweldetc','PierBearingCondition',30,'BMS','LoosenutsBoltsCrackedweldetc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','SmRstrInspectedNtMsrd','PierBearingCondition',31,'BMS','SmRstrInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','SmRstrCondSev','PierBearingCondition',32,'BMS','SmRstrCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','SmRstrCondExt','PierBearingCondition',33,'BMS','SmRstrCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('PierBearingCondition','BMS.PierBearingCondition','Remarks','PierBearingCondition',34,'BMS','Remarks');
GO
delete TableColumnDef where TableNameDescription='BMS.ReturnWall_WingWall'
GO
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','BridgeCode','ReturnWall_WingWall',1,'BMS','BridgeCode');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SurveyYear','ReturnWall_WingWall',2,'BMS','SurveyYear');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','AbutmentNo','ReturnWall_WingWall',3,'BMS','AbutmentNo');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrRWPartialCollapse','ReturnWall_WingWall',4,'BMS','SubStrRWPartialCollapse');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrIsCracked','ReturnWall_WingWall',5,'BMS','SubStrIsCracked');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrCrckLen','ReturnWall_WingWall',6,'BMS','SubStrCrckLen');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrCrckWidth','ReturnWall_WingWall',7,'BMS','SubStrCrckWidth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrCrckLoc','ReturnWall_WingWall',8,'BMS','SubStrCrckLoc');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrCrckNature','ReturnWall_WingWall',9,'BMS','SubStrCrckNature');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrCrckPercent','ReturnWall_WingWall',10,'BMS','SubStrCrckPercent');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrIsSpalling','ReturnWall_WingWall',11,'BMS','SubStrIsSpalling');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrSpallingArea','ReturnWall_WingWall',12,'BMS','SubStrSpallingArea');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrSpallingLocCnt','ReturnWall_WingWall',13,'BMS','SubStrSpallingLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrRCCExposed','ReturnWall_WingWall',14,'BMS','SubStrRCCExposed');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrRCCExposedDtls','ReturnWall_WingWall',15,'BMS','SubStrRCCExposedDtls');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrLseJntCnt','ReturnWall_WingWall',16,'BMS','SubStrLseJntCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrMtrlLsJntCnt','ReturnWall_WingWall',17,'BMS','SubStrMtrlLsJntCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrLseStonesLocCnt','ReturnWall_WingWall',18,'BMS','SubStrLseStonesLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrPlstrCond','ReturnWall_WingWall',19,'BMS','SubStrPlstrCond');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrSpiltLocCnt','ReturnWall_WingWall',20,'BMS','SubStrSpiltLocCnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrVegJnts','ReturnWall_WingWall',21,'BMS','SubStrVegJnts');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrInspectedNtMsrd','ReturnWall_WingWall',22,'BMS','SubStrInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrCondSev','ReturnWall_WingWall',23,'BMS','SubStrCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','SubStrCondExt','ReturnWall_WingWall',24,'BMS','SubStrCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','FndtionIsScoursObsv','ReturnWall_WingWall',25,'BMS','FndtionIsScoursObsv');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','FndtionScoursDepth','ReturnWall_WingWall',26,'BMS','FndtionScoursDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','FndtionIsStlmnt','ReturnWall_WingWall',27,'BMS','FndtionIsStlmnt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','FndtionStlmntDepth','ReturnWall_WingWall',28,'BMS','FndtionStlmntDepth');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','FndtionflotingbodiesImpct','ReturnWall_WingWall',29,'BMS','FndtionflotingbodiesImpct');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','FndtionInspectedNtMsrd','ReturnWall_WingWall',30,'BMS','FndtionInspectedNtMsrd');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','FndtionCondSev','ReturnWall_WingWall',31,'BMS','FndtionCondSev');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','FndtionCondExt','ReturnWall_WingWall',32,'BMS','FndtionCondExt');
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
VALUES('ReturnWall_WingWall','BMS.ReturnWall_WingWall','Remarks','ReturnWall_WingWall',33,'BMS','Remarks');
(4-4/10)