SELECT name FROM sys.all_columns WHERE OBJECT_ID=OBJECT_ID('要查询的表名') 转载于:https://www.cnblogs.com/hnsymaomao/archive/2012/09/19/2693817.html