例如:ACCESS数据库中又许多用户表,我需要获得并列出所有的用户表名称列表.
解决方案 »
- 销售登记表里没记录,行数居然返回1
- ODBC 查询 excel 数据
- MFC问题,谢谢!
- 字符串分割问题split
- 矩阵运算,用mfc
- 有了解SDK的吗????
- 求救:为什么我的这段代码老是调试出错,请大家帮忙看看
- 傻瓜问题---怎样把自己用鼠标画的任意图像保存到一个 bmp文件中去
- ▲▲▲▲▲▲我想把CRgn读取的区域存放在固定的文件里,为什么不行??▲▲▲▲▲▲▲
- CDHtmlDialog LoadFromResource显示不同Html网页时会边界不对齐的问题?
- Access向sqlserver导入数据 出现错误?????????
- 我的STL与SDK冲突的解决方法里有一条:"而且还要保证 Microsoft Platform SDK 的搜索路径必须在 STLport 和 MSVC 自己的搜索路径之前",
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)=5 ORDER BY MSysObjects.Name;
窗体:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)=-32768 ORDER BY MSysObjects.Name;
表:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;
报表:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)= -32764 ORDER BY MSysObjects.Name;
模块:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)= -32761 ORDER BY MSysObjects.Name;
宏:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (MSysObjects.Type)= -32766 ORDER BY MSysObjects.Name