该表中如何识别字段名称? [英] How to Identify Field Name is in this table?

问题描述

海，

如何识别此表中的字段名称示例"ProductId"?

FieldName数据库
产品编号aaa-DB

我只知道数据库.

这里有100张桌子.

如何识别"Productid"是哪个表?

谢谢，
Karthikeyan，Bangalore.

Hai,

how to Identify Field Name Example "ProductId" in this table?

FieldName Database
Productid aaa-DB

i know only Database.

Here 100 Tables is there.

how to Identify "Productid" is which Table?

Thanks ,
Karthikeyan,Bangalore.

推荐答案

您是否要查找包含列名"productid"的表?
如果是，那么您可以尝试以下查询:

Do you want to find the table which contains the column name ''productid''?
If yes, than you can try this query:

SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name = 'COLUMN_NAME' )

这篇关于该表中如何识别字段名称?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！