Posted by mladjo on 11/29/06 02:08

Hi.

For example:
USE AdventureWorks
GO
SELECT * FROM
INFORMATION_SCHEMA.columns


OR you can to do something like this:
SELECT * FROM SYS.views
SELECT * from SYS.TABLES

• Next in forum: Re: SQL Server 2005 objects question
• Prev in forum: Re: Fiscal year search
• Thread view: Re: SQL Server 2005 objects question

[Reply to this message]