all_tab_columns in SQL Server

Hi,
Is there any view (or table) like Oracle all_tab_columns
in SQL Server? Or is there an easy way to get all the
table names, the column names, and the column types for
one schema in SQL Server.
Thank you!
check out the view INFORMATION_SCHEMA.COLUMNS
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"david" wrote:

> Hi,
> Is there any view (or table) like Oracle all_tab_columns
> in SQL Server? Or is there an easy way to get all the
> table names, the column names, and the column types for
> one schema in SQL Server.
> Thank you!
>

all_tab_columns in SQL Server

Hi,
Is there any view (or table) like Oracle all_tab_columns
in SQL Server? Or is there an easy way to get all the
table names, the column names, and the column types for
one schema in SQL Server.
Thank you!check out the view INFORMATION_SCHEMA.COLUMNS
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"david" wrote:

> Hi,
> Is there any view (or table) like Oracle all_tab_columns
> in SQL Server? Or is there an easy way to get all the
> table names, the column names, and the column types for
> one schema in SQL Server.
> Thank you!
>