syscolumns table?

Question

Hello everyone,

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

Answer 1

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.