MS Server根据列表名查询表的字段名，字段类型，以类型长度

SELECT A.COLID AS COLUMNID,A.NAME AS COLUMNNAME,B.NAME AS DATATYPE,A.LENGTH   
AS LENGTH FROM SYSCOLUMNS A,SYSTYPES B WHERE A.ID=  
OBJECT_ID('YourTable') AND A.XTYPE=B.XTYPE  
AND B.NAME <> 'SYSNAME' ORDER BY A.COLID