is there a way to print SQL table and its Field names,
10x
cyrus
Printable View
is there a way to print SQL table and its Field names,
10x
cyrus
I think the quickest way would be to make a stored procedure, and then execute the stored procedure
Take a look at ADO's Fields collection
Quote:
ADO Collection Summary
Collection Description
Errors All the Error objects created in response to a single failure on a connection.
Parameters All the Parameter objects associated with a Command object.
Fields All the Field objects associated with a Recordset object.
Properties All the Property objects associated with a Connection, Command, Recordset or Field object.
Good Luck