CodePaste Logo
New Snippet New Snippet Recent Snippets Recent Snippets My Snippets My Snippets Web Code Search Snippets Search
Sign inor Register
Language: SQL

List all table and column names in SQL Server 2005

191 Views
Copy Code Show/Hide Line Numbers
SELECT column_name , table_name
FROM information_schema.columns
order by table_name, column_name
by Nordin
  May 12, 2010 @ 8:40pm
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