1.查询数据库指定表中的字段是否存在
select count(*) from syscolumns where id=object_id('table_name') and name='column_name';
2.查询数据库指定表是否存在
select * from sysobjects where id=object_id(N'[table_name]') and objectproperty(id,N'ISUserTable') =1;
1.查询数据库指定表中的字段是否存在
select count(*) from syscolumns where id=object_id('table_name') and name='column_name';
2.查询数据库指定表是否存在
select * from sysobjects where id=object_id(N'[table_name]') and objectproperty(id,N'ISUserTable') =1;