开发者

syscolumns table?

开发者 https://www.devze.com 2023-01-09 08:05 出处:网络
I am using SQL Server 2008 Enterprise on Windows Server 2008 Enterprise. When I open master database in开发者_开发知识库 SQL Server Management Studio. I can not find syscolumns table under Tables -> S

I am using SQL Server 2008 Enterprise on Windows Server 2008 Enterprise. When I open master database in开发者_开发知识库 SQL Server Management Studio. I can not find syscolumns table under Tables -> System Tables of master database. Where is syscolumns table?

thanks in advance, George


As of SQL Server 2005, these views are now in the sys schema - the one you're looking for is sys.columns.

SELECT *
FROM sys.columns

In SQL Server Management Studio, you'll find those views under (database) -> Views -> System Views.

syscolumns table?

See Understanding Catalog Views in SQL Server 2005/2008 or MSDN: Querying the SQL Server System Catalog for a few more hints and explanations.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号