There is another way to do much of this in SQL Server:
Use the following two queries and do a cfdump on them:
-- To get all tables in a database, just do:
SELECT * from sysobjects where type='u'
(the type='u' means just show USER tables, not system tables)
-- To get info on table, including
, cols.name
/cfquery
HTH-
Tyler
_
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 12:24 PM
To: CF-Talk
Subject: Re:How do I tell what fields are in my tables...
There is another way to do much of this in SQL Server:
Use the following two
This is the best answer.And that's the underlying reason why generic database tool is possible.Jochem has become a database guru now.
Li, Chunshen (Don)
That is why you should use the INFORMATION_SCHEMA. Just try
cfquery datasource= name=qColumns
SELECT *
FROM information_schema.columns
WHERE
3 matches
Mail list logo