MySql与Sql Server显示表结构回顾

　　2.1.　　显示表(示例表\'tb001\')的结构信息

SELECT syscolumns.name,systypes.name,syscolumns.isnullable, syscolumns.length FROM syscolumns,systypes WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = OBJECT_ID(\'tb001\')