how to use database name as a value
Posted
by user316833
on Stack Overflow
See other posts from Stack Overflow
or by user316833
Published on 2010-04-15T04:13:35Z
Indexed on
2010/04/15
4:23 UTC
Read the original article
Hit count: 167
I have more than 1000 access databases with the same table names.Each database has a unique name. In each database, I want to add column to one existing table and populate that new column (all rows in the table would be the same) with the database name. I found the example below - How can I alter this to give the new column the name of the database.
ALTER TABLE TestTable ADD NewColumn INT;
UPDATE TestTable SET NewColumn = 0;
© Stack Overflow or respective owner
