Ò»Ö»²éѯSQLServer 2005ËùÓÐÐÅÏ¢µÄÓï¾ä

select
    table_name=
    (
    case when t_c.column_id=1
        then t_o.name
        else ''
    end
    ),
    column_id=t_c.column_id,
    column_name=t_c.name,
    type=t.name,
    max_length=t_c.max_length,
    precision=isnull(t_c.precision,0),
    scale=isnull(t_c.scale,0),
    is_identity=case when t_c.is_identity=1 then '√' else '' end,   
    is_primary=
    (
        case when exists
        (
            select 1 from sys.indexes i,sys.index_columns ic,sys.objects o
                where o.type='PK' and o.name=i.name and i.index_id=ic.index_id
                    and i.object_id=ic.object_id and ic.column_id=t_c.column_id
                    and o.parent_object_id=t_c.object_id
        )
        then '√'
        else ''
        end
    ),
    is_nullable=case when t_c.is_nullable=1 then '√' else '' end,
    default_value=isnull(c.definition,''),
    description=isnull(e.value,''),
    fk_column_name=isnull(f_c.name,''),
    fk_table_name=isnull(f_o.name,'')
from sys.columns t_c