access数据库查所有表sql

access数据库查所有表sql

sql1

SELECT CAST(null AS VARCHAR(50)) AS TABLE_CAT,
CAST(null AS VARCHAR(50)) AS TABLE_SCHEM,
r.TABLE_NAME AS TABLE_NAME,
l.TABLE_TYPE,
l.REMARKS,
l.TYPE_CAT,
l.TYPE_SCHEM,
l.TYPE_NAME,
l.SELF_REFERENCING_COL_NAME,
l.REF_GENERATION,
l.HSQLDB_TYPE,
l.READ_ONLY,
l.COMMIT_ACTION 
FROM INFORMATION_SCHEMA.SYSTEM_TABLES l 
INNER JOIN UCA_METADATA.TABLES r  
ON( l.TABLE_NAME= r.ESCAPED_TABLE_NAME)  
WHERE 
TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME  LIKE '%' ESCAPE '\'

sql2

SELECT MSysObjects.Name FROM MsysObjects 
WHERE 
(Left([Name],1)<>"~") 
AND (Left$([Name],4) <> "Msys") 
AND (MSysObjects.Type)=1 
ORDER BY MSysObjects.Name;

sql3

select * from MSysObjects where type=1 and flags=0