帮助sql语句 [英] help with sql statement

问题描述

hi
是否可以在datagridview中加载表并在另一个datagridview中打开所选表，就像使用combobox打开选定的表一样？我得到了sql语句，在sql server compact中显示了包含其他模式信息的表的列表。我想用ms访问数据库尝试它。

任何帮助将不胜感激

hi Is it possible to load tables in datagridview and open selected table in another datagridview just like opening a selected table using combobox? I got the sql statement that displays list of tables with other schema information in sql server compact.I want to try it with ms access database .
any help would be appreciated

Dim Query2 As String = " Select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'TABLE'"

推荐答案

是.. 。

从INFORMATION_SCHEMA.TABLES中选择*其中table_name类似于''E％''

Yes ...
Select * from INFORMATION_SCHEMA.TABLES where table_name like ''E%''

感谢您快速回复。我会尝试一下

Thank you for quick response .I will try it out

这篇关于帮助sql语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！