locked
How to rename a column in tables of SQL PWD queries (APS) RRS feed

  • Question

  • How to rename a column in tables of  SQL PWD queries (APS) ?

    Thanks

    Ravindra Kavali

    Monday, May 23, 2016 5:56 AM

All replies

  • Let's start off by not using well-known acronyms.  What is a PWD query? Does it mean "password"?  That doesn't help, because the term "SQL password query" doesn't have a common meaning either.  What is APS?

    Perhaps your best bet is to simply search the internet or forums.  Renaming a column (or any other object) is a frequent topic.

    Monday, May 23, 2016 12:44 PM
  • Scott, I guess it's a typo and PDW = Parallel Datawarehouse with APS = Analytics Platform System is meant.

    https://www.microsoft.com/en-us/server-cloud/products/analytics-platform-system/overview.aspx


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, May 23, 2016 1:00 PM
  • Normally you should use SP_RENAME, but I don't see it in APS documentation so I guess it’s not available. Since RENAME only applies to database and table so in your case the only option left is drop and recreate table.


    Tuesday, May 24, 2016 1:56 PM
  • SQL PDW?

    Have you tried RENAME OBJECT [dbo.OriginalTableName] TO [dbo.NewTableName]


    No great genius has ever existed without some touch of madness. - Aristotle

    Tuesday, May 24, 2016 10:20 PM
  • Rename Object works when Renaming Tables,

    I did not find any method to Rename a column, APS documentation only explains renaming tables and not column.

    Thanks

    S Muchayiri


    wabibi

    Wednesday, August 23, 2017 1:58 PM