Query all sql tables

1

Good evening I'm starting in the career of developer and I'm creating an application that le an xml file.

I'm having trouble passing a command in sql database that returns all tables and their attributes (column and values).

Thank you

    
asked by anonymous 07.11.2017 / 22:54

1 answer

0

Well, look at this example:

SELECT *
FROM dbo.YourStudentTable
FOR XML PATH('Student'), ROOT ('Students')

taken from link

    
10.11.2017 / 12:33