Q: How can I find table and column names in SQLManex?
A:
You would need access to the SQL database manager. We have a stored procedure called " mnxRetrieveSchema", which will gather information about all the tables (or given tables using @tableNames parameter) and all columns (or given columns (using @columnNames parameter)
Here is example on how you can use it:
exec mnxRetrieveSchema ---- will return all tables all columns and types of the columns
exec mnxRetrieveSchema @tableNames= 'Inventor,Customer' ---- will return all columns for Inventor and Customer Table
exec mnxRetrieveSchema @columnNames= 'Custno' ---- will return all tables, which contains 'Custno' columns
|