select sys.objects.name,sys.columns.name from sys.objects
join sys.columns on sys.columns.object_id=sys.objects.object_id
where type='U '
表名、列名、字段类型、字段大小
select sys.objects.name tableName,sys.columns.name columnName,a.data_type,sys.columns.max_length from sys.objects
join sys.columns on sys.columns.object_id=sys.objects.object_id
join INFORMATION_SCHEMA.COLUMNS a on a.COLUMN_NAME=sys.columns.name
where type='U '
来自:深圳-陌城