Accessing SQL table column name without data

SET FMTONLY ON returns only metadata to the client. It can be used to test the format of the response without actually running the query.

SET FMTONLY ON;

SELECT * FROM tblDataSource;

SELECT * FROM tblPerson;

SET FMTONLY OFF;