Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
SELECTing across different databases |
Sat, May 5 2007 10:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Is it possible to get a list of all fields in all tables across a number of databases in one sql statement?
Roy Lambert |
Mon, May 7 2007 11:28 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Is it possible to get a list of all fields in all tables across a number of databases in one sql statement? >> No, since you have to connect to each database in order to query the Information schema for that database. However, you can write a stored procedure that will do so. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, May 7 2007 12:08 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
OK that's what I thought. Roy Lambert |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |