Question

怎样在access中用sql语句查询某张表的字段类型和长度？

怎样在access中用sql语句查询某张表的字段类型和长度？

Answer 1

SQL : select * from information_schema.tables
ORACLE: select table_name from user_tables
ACCESS: select name from MSysObjects where type=1 and flags=0
希望采纳谢谢~！