possible to rename db-table in active record ?

[eluser]louisl[/eluser]
To be honest I've never tried it, I've never been a fan of shortening all the table names. Active record makes the code layout pretty nice and readable so mine typically look like this:-

Code:

public function getUsersInGroup($group_id) {

  $this->db->select('users.username');
  $this->db->select('user_profiles.FirstName');
  $this->db->select('user_profiles.Surname');
  $this->db->from('users');
  $this->db->join('user_profiles', 'users.id = user_profiles.user_id', 'left');
  $this->db->join('user_groups_lookup', 'users.id = user_groups_lookup.user_id', 'left');
  $this->db->where('user_groups_lookup.group_id', $group_id);
    
  $query = $this->db->get();
  
  return $query;

}