Results 1 to 2 of 2

Thread: How to Use Metadatas

  1. 10-27-2003, 10:45 AM #1
    FreddyB
    FreddyB is offline Registered User
    Join Date
    Oct 2003
    Posts
    1

    How to Use Metadatas

    Hello... It's my first time that I write on a forum.

    I need some Urgent help...

    I'm working with SQL Server 7.0 Desktop Version. I need to write an query where shows the columns, Number of rows for each column, and the name for the database that Contains each Column...

    how can I do this?
    I use 'views', Metadata functions, but I thought that I've do this... but I can change of Database from code...

    I'd supose that "select DB_name (index)" changes tha database, but no. It only shows the name of the database.

    anybody knows a fuction which let me change databases one for one...
    An example (written) helps me too.


    Very thanks for your attention and your quikly answer...
    Reply With Quote Reply With Quote
  2. 10-27-2003, 12:12 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Do

    USE DB_NAME
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules