查是否有该表名
SELECT * FROM sys.objects WHERE name='表名'
查表字段的信息
select * from syscolumns where id=Object_Id('表名');
查是否有该表名
SELECT * FROM sys.objects WHERE name='表名'
查表字段的信息
select * from syscolumns where id=Object_Id('表名');
转载于:https://www.cnblogs.com/LuoEast/p/9479838.html