以“f_”开头的表格并以“_Data”结尾 [英] Tables starting with "f_" and ending with "_Data"

问题描述

我正在编写一个记录数据库中所有对象的函数，当我查询类型为1的MSysObjects时，我在所有数据库中得到一个名为"f_xxxxxxxxx_Data"的数据库。 （x是随机字母数字字符）。我过滤掉以〜开头的
msys表格和表格，但我没有碰到这些"f_"之前的表格，并想知道是否有人可以对它们有所了解。 （当然，我刚刚开始在ACCDB中工作）如果它们只是另一个隐藏或系统表，我可以在左边过滤
（varTableName，2）=" f_"和权利（varTableName，5）=" _Data"可靠？换句话说，这个命名约定（减去中间的字母数字）是否始终相同？希望有人可以解决这个问题！

I'm writing a function that documents all the objects in my database and when I query MSysObjects with type = 1 I'm getting one table in all my databases that has a name of "f_xxxxxxxxx_Data" (x's are random alphanumeric chars). I filter out msys tables and tables starting with ~ but I haven't run into these "f_" tables before and wondered if someone could shed some light on them. (Granted, I've just started working in ACCDB's) If they are just another hidden or system table, can I filter on Left(varTableName,2) = "f_" and Right(varTableName,5) = "_Data" reliably? In other words, is this naming convention (minus the alphanumeric in the middle) always the same? Hopefully someone can clear this up!

推荐答案

我现在不在电脑前检查，但我相信那些可能是隐藏的表用于多值和附件字段。只是我的2美分......

Hi, I'm not in front of a computer right now to check but I believe those could be the hidden tables used for multivalue and attachment fields. Just my 2 cents...

这篇关于以“f_”开头的表格并以“_Data”结尾的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！