Changing the Tables Name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ASPatel - 16 Aug 2004 15:07 GMT

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?

Reply to this Message

Rebecca Riordan - 16 Aug 2004 16:09 GMT

You should never store data in a table name. What are you trying to
achieve?

Signature

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

> 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?

Reply to this Message