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.
See Understanding Catalog Views in SQL Server 2005/2008 or MSDN: Querying the SQL Server System Catalog for a few more hints and explanations.
精彩评论