Access显示数据表链接表查询等对象SQL语句

时　间:2021-11-15 17:04:49
作　者:欧志华   ID：51519  城市：广州
摘　要:Access显示数据表链接表查询等对象SQL语句。
正　文:

'各种对象SQL语句：
'本地表+Access链接表：Select Name FROM MSysObjects Where (Flags=0) AND (Type=1) or (Type = 6)
'本地表+Access链接表 +SQL 链接表：Select Name  FROM MSysObjects Where (Flags=1048576) or (Flags=0)

    AND (Type=1) or (Type=4) or (Type=6) orDER BY MSysObjects.Name;

'本地表：Select Name FROM MSysObjects Where (Flags=0) AND (Type=1)

'Access链接表：Select Name FROM MSysObjects Where ((([Type])=6));

'Access链接表+SQL Server链接表：Select Name FROM MSysObjects Where (((Name) Not Like "~TMP*") AND ((Type)=4)) or (((Type)=6));

'查询：Select Name FROM MSysObjects Where (Flags=0) and (Type = 5)
'窗体：Select Name FROM MSysObjects Where flags=0 and type =-32768
'模块：Select Name FROM MSysObjects Where flags=0 and type =-32761
'报表：Select Name FROM MSysObjects Where (Flags=0) AND (Type=-32764);
'宏：Select Name FROM MSysObjects Where flags=0 and type =-32766

Access软件网QQ交流群 (群号:483923997) 　　　　　　Access源码网店