SQL Server 获取表或视图结构信息

------------获取表或视图的结构信息(ObjName:表名或视图名) Select o.name as Oname,c.name As name , t.name As type,c.Length As tlength From SysObjects As o , SysColumns As c , SysTypes As t Where o.type in ('u','v') And o.id = c.id And c.xtype = t.xtype and o.name=N'ObjName' Order By o.name , c.name , t.name , c.Length

转载于:https://www.cnblogs.com/luowanli/archive/2012/09/06/2673001.html

总结

以上是生活随笔为你收集整理的SQL Server 获取表或视图结构信息的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。