SQL2000中导出表定义

SQL2000中导出表定义
方法：
select
 sysobjects.name as tableName,
 syscolumns.name as ColumnName,
 systypes.name as Type,
 syscolumns.length as length,
 sysproperties.value as Des 
from
 syscolumns
 inner join sysobjects on syscolumns.id = sysobjects.id
 inner join systypes on syscolumns.xtype = systypes.xusertype
 inner join sysproperties on (syscolumns.id = sysproperties.id and syscolumns.colid = sysproperties.smallid)
where
 sysobjects.xtype = 'U'
 and sysproperties.type = 4
order by sysobjects.name