用SQL命令对BF数据表进行字段添加.doc

用SQL命今对DBF数据表进行字段添加、删除、修改 以3003.dbf数据表为例 图-1 1、添加字段 向现有的数据表中增加一个新的字段，名称为：sfzhm（身份证号码_字符型_宽度为18） 在命令窗口输入SQL命令为： alter table 3003 add column sfzhm c 18 其表如下： 图-2 2、删除字段 在现有的数据表中删除一个字段，字段名称为：bmxh 1 在命令窗口输入SQL命令为： alter table 3003 add drop bmxh 其表如下： 图-3 3、修改字段 ①在现有的数据表中修改一个字段名称，将字段名称为：sfzhm修改成身份证号码 1 在命令窗口输入SQL命令为： alter table 3003 rename sfzhm to 身份证号码 其表如下： 图-4 ②在现有的数据表中修改一个字段类型，将身份证号字段的字段类型修改为：数值型，宽度为6位保留2位小数 1 在命令窗口输入SQL命令为： alter table 3003 alter column 身份证号码 n 6,2 其表如下： 图-5 enforced thermal insulation starts checking system, issued by the thermal insulation construction before you start to notice, transfer inspection of upper and lower operation and transfer of records. For outdoor operation, pipeline equipment to effectively carry out the insulation waterproof measures fail to install protective panels in part with three tarpaulin cover, to prevent insulation from moisture. Insulation seam Michael Jackson 5mm, joints, joints 100mm, insulation thickness tolerance +10MM~ – 5mm , appropriate material elastic banding, spacing according to the design requirements, rigid insulation soft materials for construction joints tight; And large-diameter vertical pipe for high temperature pipeline in strict accordance with design drawings called for the establishment of expansion joints and holding bracket; Design requirements into a removable type of insulation, in strict accordance with specifications disconnect from the other insulation; Surface insulation boards in the technology of plastering construction of woven cloth to prevent pollution and protective panels flush with the surface interface, tight and clean. Site measurement of insulation boards for elbow shape cutting, ensure that each piece of lapped traffic, arc transition of natural, beautiful, screws up. Stampede outside construction personnel is strictly prohibited and shelve objects directly on the outer shield. In order to prevent the pollution-prone heater, channel area of secondary pollution of large-