Re: SQL Server 2005 with VB.net 2005

Omar,

All of these commands return rowsets. Just read the rows from your query
and do whatever you want in VB, such as putting then into a string array.
(If I understand your question.)

RLF
"Omar Abid" <omar.abid2006@xxxxxxxxx> wrote in message
news:1181553716.912264.245270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On 9 juin, 15:04, "Russell Fields" <russellfie...@xxxxxxxxxx> 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...@xxxxxxxxx> wrote in message

news:1181389760.532598.147360@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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...@xxxxxxxxxxx
omar.abid2...@xxxxxxxxx
Omar abid

thx, but how to get the tables name into strings ?



.

Relevant Pages

  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cannot Generate SSPI Context - help
    ... I have used the following DSN-less string: ... Microsoft OLE DB Provider for SQL Server error '80004005' ... When a connection is "trusted," it means ... > How would one connect to a remote SQL Server using Windows authen? ...
    (microsoft.public.inetserver.asp.db)
  • Re: INSERT Query problem with Quotes & Apostrophes
    ... I've got front-ends that go against both Jet and SQL Server databases. ... InputText As String, _ ... >> Delimiter, Delimiter & Delimiter) ... dDateTime, ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADO.NET 2.0 saving single space to SQL?
    ... It is code someone else wrote quite some time ago and all of the string ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: using OpenXML in T-sql?
    ... am not the most senior person in sql server programming, ... especially xml stuff. ... style string in place of an array without the additional ... >delimited strings and opts for the xml string instead. ...
    (microsoft.public.sqlserver.programming)
Loading