how can i see the real table name??

Hot Topic

How Events work and how to control them
Sending SMTP mail using C#
How can I get images from database?
Creating a reference to a value type
Using OS to open files
WDS 2.6 EID Encoding
Unloading an Assembly
MySql error: should be string, but is seen as double
The Decimal Type
VS 8 Performance makes it unuseable

Visual C#

deleting from text file
Indexing never ends with Norton Protected Recycle Bin
How can i insert a file in image column in c#??.
Serilization of a generic List of a custom type, how?
How to get a list of all shared folders?
Get the unicode of string
StreamReader and File Position
Why all these get/set-methods instead of public variables?
MessageBox.Show method
Scrolling causes flicker

how can i see the real table name??

when i use DataAdapter to fill a dataset,but the real table name in original database has been changed,for ex: it will be changed as" table" ."table1"....and so forth..

can i get the real name of the table and how could you tell me




Answer this question

how can i see the real table name??

  • Peter Dorotiak

    really

    but how does the server explorer know the table name of the database



  • nkpatt

    Now I don't know what are you looking for. If you need to see the tables in database you can use system views for that, for example:

    SELECT * FROM INFORMATION_SCHEMA.TABLES

    If you alway know that table will begin with some string 'table', than you can make some filter from previous view and see what is the latest table that you need. But it will be better to use view.



  • toront

    oh ,i am just finding the system table.....

    thank you for reminding me:D



  • Stefan Kratzert

    You can't directly find out. But you can use views instead or stored procedures. So when the table is changed then the view or stored procedure should be changed also but result from them will be always the same.

  • how can i see the real table name??
Answer this question