jeudi 3 décembre 2015

How to display all table names once followed by all column names in SQL Server?

My requirement is to display the table name once followed by all column names of that table. I am not able to do that. And I wanted it to be done with query itself not with the stored procedure. Always, it repeats the table names with the column names. I want table name(Entity) to be displayed once and all the column names(attributes) to be displayed under that. Then next table name(Entity) followed by its column names(attributes) and so on.

Thank you in advance.

Aucun commentaire:

Enregistrer un commentaire