Hiya,
You can rename the tables, however, you must do this through application designer, otherwise PS will not be able to see the existing tables, as it does not use the underlying system tables (sysobjects in MS-SQL) to see the tables, but a PS system table.
HTH
Tim