 |
| 我的知识库 |
 |
|
|
通过查询返回数据库对象的名称 |
|
[ 作者： | 文章来源： 编程中国 | 点击数： 527 | 更新时间： 2007-11-4 8:58:44 ] |
使用下列 SQL 语句来获取你想要的
查询：
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)=5 ORDER BY MSysObjects.Name; Www~Spdns~com
窗体： 南通服务器网
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 (MSysObjects.Type)= -32764 ORDER BY MSysObjects.Name; Spdns_com
模块： 中.国.南通服务器网
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)= -32761 ORDER BY MSysObjects.Name; Spdns@com
宏： 南通服务器网
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)= -32766 ORDER BY MSysObjects.Name; 中国南通服务器网
|
|
|
|
|
