select * from syscolumns where id=Object_Id(‘“+TableName+”‘);
SELECT * FROM " + DataBaseName + "..SysObjects Where XType=‘U‘ or XType=‘V‘ ORDER BY Name
关于SQL Server对于表的一些查询
原文:https://www.cnblogs.com/A-R-E-S/p/10488024.html