Get the entire list of table's and column's using single line Sql query.Is that possible?

Question

I have searched for this....but no solution. I want a single query which produces all table names and their column names..

Every platform is different. Is this for Oracle, SQL Server, MS Access? Note: SQL is not SQL Server — Nick.Mc, Aug 01 '17 at 05:08
Possible duplicate of [Concatenate many rows into a single text string?](https://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string) — Mansoor, Aug 01 '17 at 05:13

score 1 · Answer 1 · answered Aug 01 '17 at 05:17

1

I think this will give you what you want

SELECT COLUMN_NAME, TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS

answered Aug 01 '17 at 05:17

asmgx

score 0 · Answer 2 · edited Aug 01 '17 at 07:22

0

SELECT t.name AS TableName,
    c.name AS ColumnName
FROM sys.tables t
    INNER JOIN sys.columns c ON c.object_id = t.object_id;

edited Aug 01 '17 at 07:22

ASpirin

answered Aug 01 '17 at 06:32

Gagan Sharma

2 Answers2