代码
select
o.name
as
TableName, c.
[
name
]
, s.name
as
colType, co.length
from
sys.columns c
inner
join
sys.types s
on
c.user_type_id
=
s.user_type_id
inner
join
sys.objects o
on
c.
object_id
=
o.
object_id
inner
join
syscolumns co
on
c.
object_id
=
co.id
and
c.column_id
=
colid
转载于:https://www.cnblogs.com/lfzwenzhu/archive/2010/11/24/1886901.html
