查資料庫中有XX欄位的table

查資料庫中有XX欄位的table

    Select A.NAME AS Table_Name,B.NAME AS Columns_Name From SysObjects A Inner Join SysColumns B On A.ID=B.ID Where A.xType='U' AND B.NAME='customer'

    Order By A.Name,B.ColID