CodePaste.NET - Get All Columns

Subscribe

Discuss

What's new

What is it

New Snippet

Recent Snippets

Recent Snippets

My Snippets

My Snippets

Web Code

Search Snippets

Search

Sign inor Register

Language: SQL

Get All Columns

127 Views

Copy Code

Show/Hide Line Numbers

SELECT table_name=sysobjects.name,
         column_name=syscolumns.name,
         datatype=systypes.name,
         length=syscolumns.length
    FROM sysobjects 
    JOIN syscolumns ON sysobjects.id = syscolumns.id
    JOIN systypes ON syscolumns.xtype=systypes.xtype
   WHERE sysobjects.xtype='U'
ORDER BY sysobjects.name,syscolumns.colid

by caltuntas
January 03, 2010 @ 11:37pm

Tags:

Add a comment

Report Abuse

brought to you by:

West Wind Techologies

If you find this site useful and use it frequently please consider making a donation to support this free service.

Donate