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

使用下列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;