Re: Help with Query

Next message: Steve Kass: "Re: Dates Result Set"
Previous message: Dave Lugo: "Help with Query"
In reply to: Dave Lugo: "Help with Query"
Next in thread: Dave Lugo: "Re: Help with Query"
Reply: Dave Lugo: "Re: Help with Query"
Messages sorted by: [ date ] [ thread ]

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 04/21/04

Date: Wed, 21 Apr 2004 22:24:17 +0200

On Wed, 21 Apr 2004 12:35:42 -0700, Dave Lugo wrote:

>I need help in generating a query that will give me all
>my DB tables and associated columns.
>
>Thanks

Hi Dave,

Try the following:

SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS

Best, Hugo

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)