获取SQL Server数据库表的列名

SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length

FROM syscolumns, systypes

WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = object_id('ChildrenCustomer') and syscolumns.name like '%obile'