Skip to main content
U
unixsyadm
Known Participant
October 26, 2006
Question

Describe database

  • October 26, 2006
  • 1 reply
  • 529 views
I want to create an application that will "Describe a database" And allow the user to select the database table. Upon selection I would like to query the table selected and display the data.

Can we "Describe the database and output the table names in CF?
by the way I am using MS SQL


Thank you

AIM: Unixsyadm
Tim Rubel
This topic has been closed for replies.

1 reply

P
philh
Inspiring
October 29, 2006
SELECT DISTINCT table_name FROM INFORMATION_SCHEMA.columns where left(table_name,3) <> 'sys'
ORDER BY table_name

You could further refine this by including other system tables, or using a different view from the schema.

HTH,
U
unixsyadmAuthor
Known Participant
November 2, 2006
Thank you, I got the results I wanted except that one of the System types (dtproperties) is not exclucde Any idea why this might be happening?

I attempted to excude all types that were not uses by using th != 'User" operator but produced 0 results

These are the results I want except I don't want dtproperties either.


Thank you,

Tim
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices