Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

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