CODEWITHSUNDEEP
sql-server-2008
George2
George2

Reputation: 45771

syscolumns table?

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

Upvotes: 0

Views: 4819

Answers (1)

marc_s
marc_s

Reputation: 754538

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.

alt text

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

Upvotes: 4

Related Questions