获取列名&值的表名 [英] get Column name & table name from value

问题描述

嗨 实际上，我有一个新客户，&他们的数据库没有标准的命名约定和我的应用程序是经典的asp.我有一个表单，其中表单在不同的文本框中有很多值，因此很难跟踪来自哪个表的值.也没有erd.

我需要一个查询，通过提供 Value
我可以从中获取表名和列名

谢谢

Hi Actually i have a new client ,& their Database has no standard naming conventions & the application is in classic asp.I have a form in which a form there are many values in the different textboxes ,it it very difficult to trace the value come from which table.& also there is no erd.

I need a query from which i can get the table name with column name by giving Value


Thanks

推荐答案

您是否了解该值不包含有关数据库元数据的信息，所以无论您如何操作，都需要搜索所有数据库?

这并非不可能.这是一种严重的滥用行为，不仅效率低下，而且还违反了关系数据库的整体思想.

另外，您问问题的方法很错误.您不是在问您想要什么；你问自己想要什么，这是不一样的.不，我不敢相信您确实需要这样的查询，我会更容易相信您不真正理解您的问题.换句话说，您应该从对最终目标的解释开始，而不要使用关于如何实现目标的想法.也许您的问题不是没有希望的；这样一来，我们很可能会为您提供一些真正有用的建议.

—SA

Do you understand that the value along carries no information on the database metadata, so you would need to search through all the database, no matter how you do it?

Not that this is impossible. This is just such a bad abuse which is not just inefficient — it defeats the purpose of the whole idea of relationship databases.

Also, you very approach to asking question is wrong. You are asking not about what you want; you asking about what you think you want, and this is not the same. No, I cannot believe you really need such query, I would easier believe you don''t really understand your problem. In other words, you should start with explanation of your ultimate goal, without using you ideas on how it should be implemented. Perhaps you problem is not that hopeless; it''s much more likely that this way we would advice you something really useful.

—SA

这篇关于获取列名&值的表名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！