如何使用以下sql查询获取列名？ [英] How to fetch column name with the below sql query?

问题描述

如何使用以下sql查询获取列名？

How to fetch column name with the below sql query?

SELECT 'CREATE INDEX ' +  i.name + ' ON ' + t.name + '('+ c.name +')' FROM 
   sys.indexes i 
   JOIN 
   sys.tables t ON 
   i.object_id = t.object_id 
   JOIN sys.schemas AS s
   ON  s.[schema_id] = t.[schema_id]
  -- and s.[schema_id] = c.[schema_id]
   WHERE i.index_id >= 1 
   and  EXISTS 
	(
	  SELECT 1 FROM sys.identity_columns
		WHERE [object_id] = t.[object_id]
	)
   ORDER BY t.name, i.name;

我尝试过：



如何使用以下sql查询获取列名？

What I have tried:

How to fetch column name with the below sql query?

SELECT 'CREATE INDEX ' +  i.name + ' ON ' + t.name + '('+ c.name +')' FROM 
   sys.indexes i 
   JOIN 
   sys.tables t ON 
   i.object_id = t.object_id 
   JOIN sys.schemas AS s
   ON  s.[schema_id] = t.[schema_id]
  -- and s.[schema_id] = c.[schema_id]
   WHERE i.index_id >= 1 
   and  EXISTS 
	(
	  SELECT 1 FROM sys.identity_columns
		WHERE [object_id] = t.[object_id]
	)
   ORDER BY t.name, i.name;

推荐答案

你也可以使用这个

You can also use this

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.yourTableName') 

这篇关于如何使用以下sql查询获取列名？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！