Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    15

    Thumbs up Unanswered: I want all the Table names

    hi

    I am using Sql Server 2000 as Back end. i am using Visual Basic as front End. i want all the Table Names from the particluar database(i Know the Database name) and load it into an Recordset. how to do that. is there any stored Procedure for that to get all the tables names.

    Thanking you

    Regards

    Gandhi
    Last edited by dgchoudary; 07-09-02 at 06:40.

  2. #2
    Join Date
    Jul 2002
    Location
    India
    Posts
    13
    You can issue the following select statement to any database in SQL Server....


    Select Name from Sysobjects Where type= 'U'
    Balaji

  3. #3
    Join Date
    Jul 2002
    Posts
    15
    Originally posted by pcmbalaji
    You can issue the following select statement to any database in SQL Server....


    Select Name from Sysobjects Where type= 'U'

    Thank u it is working fine

    Regrds
    gandhi

Posting Permissions

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