SQLSERVER的话:
IF EXISTS(SELECT 1 FROM [sys].[columns] WHERE [name]='列名' AND [object_id]=object_id('表名')) print 'yes'ELSE print 'no'