工具/材料:Management Studio。
1、首先在桌面上,点击“Management Studio”图标。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a90fe1a9ee9a6773912b31beeba?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、之后在该界面中,点击左上角“新建查询”选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbfc6c6706e16d8bc3eb1354168?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、接着在该界面中,输入查询数据库是否有某个字段的sql语句“select count(*) from information_schema.columns where table_name = 'test1' and column_name = 'grade'”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8014c086e061d952b6ff26c74f40ad162d9cabd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后在该界面中,点击左上方“执行”按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513d1416a98a326d55fbb2fbd922?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、最后在该界面中,显示查询数据库有某个字段。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8601a18b87d6277f89aef76c27381f30e924fc22?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)