How to change table name when script a table from SQL Server SMO

Question

Let's say I have a table "foo" that I want to script out using SMO. Is there a way to have it so that in the generated script the table has a different name such as "foo2"?

Database db = sqlServer.Databases["testdb"];
Table foo = db.Tables["foo"];
foo.Name = "foo2";

If I do this, I get this exception when I try to set foo.Name:

"Cannot perform the operation on this object, because the object is a member of a collection."

Is there any way to do this with SMO?

Answer 1

You'll have to put the output of the Script method into a string variable and use Replace to substitute the name.

Answer 2

You can create an in memory new table with the new name and then script that table.

You can find the code to copy table at Copying a table using SMO

Instead of calling the Create() on the new table, you need to simply call Script().