Renaming Registered TAbles

[balraj]

Hi Community,

I've tables registered using ODBC Library and I renamed those registered tables. When I schedule the Data Query which uses the renamed tables. Does they get updated or because I renamed it'll give me an error.

Kindly clarify this doubt.

Kind Regards,

Balraj P

[LinusH]

Please describe the steps in much more detail.
What is Data Query, in what tool are you?

Generally, renaming in metadata doesn't automatically renames physical data, and vice versa.

[balraj]

Hi @LinusH,

I'm using SAS VA,

1. In SMC I've imported tables using ODBC server and registered them. I've renamed the Imported tables as per my convinience.

2. In SAS VA Databuilder, I've used the renamed tables to build my Data Query and scheduled it.

3. When scheduler runs it fetches data from DB.

will the data imported by the scheduler updates the renamed tables or not is my question?

Kind Regards

Balraj P

[LinusH · Accepted solution]

If you just renamed the metadata name (not the physical name in metadata) it should work.

But why do you ask? If you already renamed them, just try...?

[balraj]

Yeah did that It's working. 🙂 forgot to post here.. Thank you so much 🙂