Is their any other way or sql
query to find the database table names with a particular column than shown below,
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'NameID'
Is their any other way or sql
query to find the database table names with a particular column than shown below,
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'NameID'
4条答案
按热度按时间euoag5mw1#
在SQL Server中,您可以查询
sys.columns
。类似于:
如果您在多个架构中有表,则可能需要额外的查找来解析架构名称。
rkkpypqq2#
you can run this query
jaxagkaj3#
For Oracle Database. Use the below query:
If you’ve got DBA privileges, you can try this command instead:
hmae6n7t4#