MYSQL workbench

Databases
1

Does anyone know if there is an easy way to print a list of columns from a Table from a printer. Its not critical at all, just wondering if there is an easy way from within Workbench to do it…?

2

Have you tried a SQL query like:

SHOW COLUMNS FROM my_table_name

Or the old stand by of:

SELECT column_name, data_type, character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_name = 'my_table_name';
1 Like
3

Thanks Scott, I got -SHOW COLUMNS FROM my_table_name- to list the columns then i exported the list to csv and opened it in notepad for the print. Thanx kind sir

1 Like