项目需要查询表的字段相关信息,包含名称、长度、精度、是否主键。查了半天达梦数据库的手册,感觉好绕啊,如果有更简单的方法请在评论里添加下,在这里记录下SQL
@Select("select t1.column_name, t1.data_type, t1.data_length, t1.data_scale, t2.constraint_type from user_tab_columns t1" +
" left join" +
" (select t1.column_name, t1.table_name, t2.constraint_type from user_ind_columns t1 left join user_constraints t2 " +
" on t1.index_name=t2.index_name" +
") t2" +
" on t1.table_name=t2.table_name and t1.column_name=t2.column_name" +
" where t1.table_name= '${tableName}'")