select t.column_description,concat(’/**’,convert(nvarchar(max),t.column_description),’*/’,’ @TableField("’,t.column_name,’")’,'private ‘,CASE t.column_type
WHEN ‘varchar’ THEN ‘String’
WHEN ‘nvarchar ’ THEN ‘String’
WHEN ‘ntext’ THEN ‘String’
WHEN ‘bit’ THEN ‘boolean’
WHEN ‘int’ THEN ‘Integer’
WHEN ‘tinyint’ THEN ‘Integer’
WHEN ‘bigint’ THEN ‘Long’
WHEN ‘datetime’ THEN ‘long’
WHEN ‘date’ THEN ‘Date’
ELSE t.column_type
END
,’ ‘,t.column_name,’;’) from (
SELECT A.name AS table_name,
B.name AS column_name, C.value AS column_description ,D.name as column_type
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
LEFT JOIN systypes D on B.user_type_id = D.xusertype
WHERE A.name = ‘表名’) t;
将表名改为 你所要转化的 表名