SELECT TOP 10 name from [sysobjects] where type='u' and name LIKE '%table_name%' --从用户表中模糊查询表,type='s'为从系统表中查询
Select name FROM SysColumns Where id=Object_Id('table_name') --查询表table_name的所有列