Detecting Table Names

Results 1 to 2 of 2

Thread: Detecting Table Names

  1. #1
    Join Date
    Dec 1969

    Default Detecting Table Names

    Does anyone know how to detect the names of each table in an SQL database? I&#039m sure it can be done, because when you add a data connection to Visual Interdev, it shows each available table. Any Ideas?<BR><BR>Thanks,<BR>-Ryan

  2. #2
    Join Date
    Dec 1969

    Default RE: Detecting Table Names

    I found this as a view in one of my SQL server 7 db&#039s. I think you could get it to work.<BR><BR>SELECT DISTINCT <BR> db_name() AS TABLE_CATALOG, user_name(o.uid) <BR> AS TABLE_SCHEMA, AS TABLE_NAME<BR>FROM sysobjects o<BR>WHERE o.xtype IN (&#039U&#039, &#039V&#039) AND permissions( != 0<BR><BR>Let us know.<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts