4
Answers

How to get all columns name in SQL Server.

Photo of Deepak M

Deepak M

3y
843
1

How can i get all tables name with its columns name in a table in SQL Server ?
For example

tablename    columnsname
table1            column1,column2,column3...
table2            column1,column2,column3...
table3            column1,column2,column3...

Answers (4)