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 datatypes etc, use the following SQL Server stored proc (comes with database):
sp_help [yourTableName]
Will return seven result sets; the second one is the interesting one - run it is query analyzer to see what you can get from it. I use this instead of Enterprise Manager, for the most part - Query Analyzer is much lower overhead and faster.
>Thanks Critz!
>
>This worked like a charm.
>
>
>I'm alos going to look at what you recomended Philip.
>
>
>Thanks to all!
>
>Brian
>
>
>oi cf!!
>
>select top 10 * from table
><cfdump var="#query#">
>
>or output query.columnlist
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
