Changing the Tables Name

  • Thread starter Thread starter ASPatel
  • Start date Start date
A

ASPatel

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