选择所有表和列 [英] select all Tables and Columns

问题描述

我想编写一个选择查询，该查询选择数据库的所有表和列.可以使用任何版本的sql server(2000,2005,2008)数据库.我写了一个Qyery:-

  SELECT  t.name  AS  table_name，
c.name  AS  column_name
 FROM  sys.tables  AS  t
 INNER   JOIN  sys.columns c  ON  t . OBJECT_ID  = c. OBJECT_ID  

但是在sql server 2005中不起作用....

解决方案

您可以使用:

  SELECT  TABLE_NAME，COLUMN_NAME  FROM  INFORMATION_SCHEMA.COLUMNS 

http://www.sentientbeings.com/2012/01/t-sql-list-all-columns-in-all-tables/ [此处 [SELECT t.name AS table_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

but it not work in sql server 2005....

解决方案

You could just use:

SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

http://www.sentientbeings.com/2012/01/t-sql-list-all-columns-in-all-tables/[^]

Use Information_schema views as per the OriginalGriff answer, in addition to go through the below link for more information
Here[^]

Thanks
--RA

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