"Omar Abid" <omar.abid2006@gmail.com> wrote in message
news:1181389760.532598.147360@k79g2000hse.googlegroups.com...
> Hi every body,
> Im using VB 2005 to create a program that open SQL Data base
> The problem that i want to detect the tables of a database
> so how can i know a data base tables instantly
> Thank you
> omar.abid@hotmail.com
> omar.abid2006@gmail.com
> Omar abid
>

On 9 juin, 15:04, "Russell Fields" <russellfie...@nomail.com> wrote:
> Omar,
>
> For tables to which the user has rights:
> EXEC sp_tables
>
> For all tables:
> In SQL Server 2000 and 2005
> SELECT * FROM INFORMATION_SCHEMA.TABLES
>
> In SQL Server 2005
> SELECT * FROM sys.tables
>
> For SQL Server 2005 permissions to this information is more restricted and
> may require the user to have VIEW DEFINITIONS rights in order to see
> everything.
>
> RLF
>
> "Omar Abid" <omar.abid2...@gmail.com> wrote in message
>
> news:1181389760.532598.147360@k79g2000hse.googlegroups.com...
>
> > Hi every body,
> > Im using VB 2005 to create a program that open SQL Data base
> > The problem that i want to detect the tables of a database
> > so how can i know a data base tables instantly
> > Thank you
> > omar.a...@hotmail.com
> > omar.abid2...@gmail.com
> > Omar abid

"Omar Abid" <omar.abid2006@gmail.com> wrote in message
news:1181553716.912264.245270@c77g2000hse.googlegroups.com...
> On 9 juin, 15:04, "Russell Fields" <russellfie...@nomail.com> wrote:
>> Omar,
>>
>> For tables to which the user has rights:
>> EXEC sp_tables
>>
>> For all tables:
>> In SQL Server 2000 and 2005
>> SELECT * FROM INFORMATION_SCHEMA.TABLES
>>
>> In SQL Server 2005
>> SELECT * FROM sys.tables
>>
>> For SQL Server 2005 permissions to this information is more restricted
>> and
>> may require the user to have VIEW DEFINITIONS rights in order to see
>> everything.
>>
>> RLF
>>
>> "Omar Abid" <omar.abid2...@gmail.com> wrote in message
>>
>> news:1181389760.532598.147360@k79g2000hse.googlegroups.com...
>>
>> > Hi every body,
>> > Im using VB 2005 to create a program that open SQL Data base
>> > The problem that i want to detect the tables of a database
>> > so how can i know a data base tables instantly
>> > Thank you
>> > omar.a...@hotmail.com
>> > omar.abid2...@gmail.com
>> > Omar abid
>
> thx, but how to get the tables name into strings ?
>