摘要:
SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length FROM syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = object_id('表名')例如:SELECT syscolumns.name as '字段',systypes.name+'('+convert(varchar(20),syscolumns.length) 阅读全文