sql表字段类型查询及数据库编码格式查询
1.查询字段类型select a.name as [column],b.name as typefrom syscolumns a,systypes bwhere a.id=object_id(‘表’) and a.xtype=b.xtype and a.name=‘字段’2.查询数据编码格式SELECT COLLATIONPROPERTY(‘Chinese_PRC_Stroke_CI...
原创
2020-03-03 21:15:54 ·
1172 阅读 ·
0 评论