Yeah, you can do it with the help of sys.columns and sys.tables
After connecting to SQL Server and choosing the database you will work with (which is usually just the DEFAULT DATABASE specified in the connection string), you can do:
More specifically, you will be interested in (most likely)
FROM sys.columns AS C, sys.tables AS T
WHERE C.objectid = T.objectid
AND T.name = '...name of the table you want to work with...'
You might get some column_id's twice...I think that's because of how keys are recorded. Just pick the one that has the ordinary type name, not something like "sysname".
select c.column_id, c.name, t.name, c.max_length, c.precision, c.scale
from sys.columns as c, sys.types as t, sys.tables as tbl
where tbl.name = '...name of table...'
and c.object_id = tbl.object_id
and c.system_type_id = t.system_type_id
order by column_id
I assume you want to convert ' to \' so you can dump the data from MySQL into a format usable for import into MySQL?