>[info]语句格式 select column_name as 字段名,data_type as 数据类型, ISNULL(ISNULL(ISNULL(character_maximum_length,numeric_precision),datetime_precision),1) as 长度 from information_schema.columns where table_name ='人员信息表' >[info]SQL语句 select column_name as 字段名,data_type as 数据类型, ISNULL(ISNULL(ISNULL(character_maximum_length,numeric_precision),datetime_precision),1) as 长度 from information_schema.columns where table_name ='人员信息表' >[info]语句说明 此语句在GSQL6.5.0.4绿色版下不可用。 获取人员信息表中的字段名、字段类型、字段长度。