通过查询返回数据库对象的名称

核心提示：使用下列SQL语句来获取你想要的查询:SELECTMSysObjects.NameFROMMsysObjectsWHERE(Left$([Name],1)<>"~")AND(MSysObjects.Type)=5ORDERBYMSysObjects.Name;窗体:SELECTMSysO

使用下列SQL语句来获取你想要的

查询:

SELECTMSysObjects.NameFROMMsysObjectsWHERE(Left$([Name],1)<>"~")AND(MSysObjects.Type)=5ORDERBYMSysObjects.Name;

窗体:

SELECTMSysObjects.NameFROMMsysObjectsWHERE(Left$([Name],1)<>"~")AND(MSysObjects.Type)=-32768ORDERBYMSysObjects.Name;

表:

SELECTMSysObjects.NameFROMMsysObjectsWHERE(Left$([Name],1)<>"~")AND(Left$([Name],4)<>"Msys")AND(MSysObjects.Type)=1ORDERBYMSysObjects.Name;

报表:

SELECTMSysObjects.NameFROMMsysObjectsWHERE(Left$([Name],1)<>"~")AND(MSysObjects.Type)=-32764ORDERBYMSysObjects.Name;

模块:

SELECTMSysObjects.NameFROMMsysObjectsWHERE(Left$([Name],1)<>"~")AND(MSysObjects.Type)=-32761ORDERBYMSysObjects.Name;

宏:

SELECTMSysObjects.NameFROMMsysObjectsWHERE(Left$([Name],1)<>"~")AND(MSysObjects.Type)=-32766ORDERBYMSysObjects.Name;