We never stop looking ... ...for a better way

Events

There are no upcoming events

Older Stories

Friday 23-Sep


Monday 05-Sep


Saturday 20-Aug


Wednesday 13-Jul


Saturday 25-Jun


Wednesday 22-Jun


Sunday 08-May


Thursday 10-Feb


Wednesday 17-Nov

Welcome to Woods Applied Technologies
Saturday, September 04 2010 @ 02:55 AM MDT

SQL Server database listing

Monday, May 15 2006 @ 01:48 PM MDT

Contributed by: cary

Views: 984

research libraryHow to list a the databases and tables in T-SQLselect name from master.dbo.sysdatabases
gives you all the databases on a server....(7.0 and 2000)

list tables
SELECT *FROM sysobjects where xtype = 'u'

Story Options

Trackback

Trackback URL for this entry: http://www.watcorp.com/trackback.php?id=20060515134836179

No trackback comments for this entry.
SQL Server database listing | 1 comments | Create New Account
The following comments are owned by whomever posted them. This site is not responsible for what they say.
SQL Server database listing
Authored by: Neverever on Tuesday, January 05 2010 @ 03:07 AM MST
Thanks for that wonderful essay. It was a really interesting entry.
 Copyright © 2010 Woods Applied Technologies
 All trademarks and copyrights on this page are owned by their respective owners. 		Powered By Geeklog 
Created this page in 0.15 seconds