If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing the Tables Name
I have to design a database which will have 2 Tables
Table1 and Table2. When data in Table1 Changes i can generate a number thru query1/Expr1(based on data of Table1) and every time this happens i want to change name of Table2 to that number eg.40326 can this be done? |
#2
|
|||
|
|||
You should never store data in a table name. What are you trying to
achieve? -- Rebecca Riordan, MVP Seeing Data: Designing User Interfaces Designing Relational Database Systems, 2nd Edition www.awprofessional.com Microsoft SQL Server 2000 Programming Step by Step Microsoft ADO.NET Step by Step www.microsoft.com/mspress "ASPatel" wrote in message ... I have to design a database which will have 2 Tables Table1 and Table2. When data in Table1 Changes i can generate a number thru query1/Expr1(based on data of Table1) and every time this happens i want to change name of Table2 to that number eg.40326 can this be done? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
searching for "join tables" and "join word tables" | Uncle Bill | Tables | 1 | June 11th, 2004 09:33 PM |
Limit to Number of Tables | T'Kai | Database Design | 1 | June 8th, 2004 03:44 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
How do I design a database based on the information that will be stored? - Copy of Tables and hirearchies.zip (0/1) | Jim | Database Design | 1 | June 1st, 2004 01:44 PM |