-
Run this query to get all the table and columns:
SELECT so.name TableName,sc.name ColumnName,sc.system_type_id,sc.user_type_id,sc.max_length,sc.precision,sc.scale,sc.is_nullable,sc.is_identity
FROM SYS.OBJECTS so
JOIN sys.columns sc ON sc.OBJECT_ID=so.OBJECT_ID
WHERE so.type='U' ORDER BY so.name,sc.name
-
Click on the empty cell above the 1 and left of the first column to select all, or CTRL+A.
- Right click on the grid > Copy with headers. Headers are required for the parser.
-
Paste the result into the textarea.
Remember to check the database column and the generated POCOs (incase this tool fails to convert stuff).