Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Renaming Columns in DB Table: Apex SQL or Examine Dependenci

  1. Feb 17, 2016 #1


    User Avatar
    Science Advisor
    Gold Member

    Hi All,
    Just curious as to what those with experience in creating databases believe is the best method when
    renaming databases: using Apex SQL , which (supposedly) automatically checks for dependencies or
    just sitting down , looking at the dependencies and doing the changes one by one as needed? This is
    for a class project. Also, can anyone recommend a good source for schemas to use , maybe
    make changes to (EDIT: The project is for a company)?
  2. jcsd
  3. Feb 17, 2016 #2


    Staff: Mentor

  4. Feb 17, 2016 #3
    Renaming databases is not an issue in modern RDBMSs as we work with connections in which the name of the database is an arbitrary parameter. Do you mean renaming tables and/or columns within databases?

    In the real world (e.g. for a company), business logic is implemented in code which is linked to database structure. Ideally this is abstracted so that the business logic layer is separated from the data storage layer by at least one level, so alterations to the database schema need only be dealt with by altering the relevant code in the Data Access Layer (DAL)/Data Access Objects (DAO)/Object Relational Models (ORM)/whatever the paradigm you are using.
  5. Feb 18, 2016 #4


    User Avatar
    Science Advisor
    Gold Member

    Thanks, Anchovy, I do mean renaming within a database. I did get a warning message from my MSSQL2014 in that respect for some reason after I renamed a table within a database. And there were error messages even when I "inverted" the renaming (i.e., I gave the table the original name), I had some. And I guess we use the names DDL (Data Definition Language) and DML (Data Manipulation Language) respectively, and in this case the renaming is done within a DDL , i.e., writing code , not doing within a GUI (Graphical Interface).
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook