我需要使用列名'transaction ID'来获取数据库中的所有表 [英] I need to get all tables in the database with the column name 'transaction ID'

问题描述

需要的表格包含交易ID栏



我尝试过：



从information_schema.columns中选择table_name，column_name，其中column_name像'％Transaction ID％'

Need tables consists of Transaction ID column

What I have tried:

select table_name,column_name from information_schema.columns where column_name like '%Transaction ID%'

推荐答案

如果我运行你的代码 - 稍微改变，因为我不没有任何交易ID列 - 我得到了我的期望：

And if I run your code - slightly changed since I don't have any "Transaction ID" columns - I get what I expect:

select table_name,column_name from information_schema.columns where column_name like '%ID%'

table_name  column_name
CCr         id
Stock       Id
Stock       ItemID
Folder      DefaultPhotoID
Folder      FolderID
Gallery     FolderID
Gallery     PhotoID
Invoices    id
Managers    ID
Managers    ManagerID
ChatEvents  Id
Salesman    SalesID

所以我最好的猜测是你要搜索的名称是错误的：TRansaction ID可能是Transaction_ID或TransactionID

So my best guess is that the name you are searching for is wrong: "TRansaction ID" may be "Transaction_ID" or "TransactionID"

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_CATALOG ='DatabaseName'和COLUMN_NAME ='Transaction_ID'







希望这会对你有所帮助。



谢谢

Amit Kalshetti

[e-mail]

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG='DatabaseName' and COLUMN_NAME='Transaction_ID'



Hope this will help you.

Thank you
Amit Kalshetti
[e-mail]

这篇关于我需要使用列名'transaction ID'来获取数据库中的所有表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！