using syscolumns and sysobjects

»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books

»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects

»Competition
Community
Winners
Prizes
Write For Us
Members

»Other Resources
Links
Dotnet Resources

using syscolumns and sysobjects

A simple query to list the tables and fields in a database



Select o.name as 'Table', c.name as 'Field'



From dbo.sysobjects o, dbo.syscolumns c



Where o.id = c.id



            and o.xtype = 'U'



Order by o.name, c.colid

Have a Question and dont know the answer post it below and get answers in minutes

Due to spam this feature is disabled
To get answers fast , make sure you enter a detailed subject for example: "DataGrid issues need answer" not "DataGrid"

Subject:

Catjegory Name:

Message: