- create easy reference
- shorten lengthy object name
create synonym d_sum
for dept_sum_vu;
Results
create synonym succeeded.
===> SQL Queries: Drop a Synonym
drop synonym d_sum;
Results
drop synonym d_sum succeeded.
Execute your life day to day...you might not know what u're dropping ...-Cik Peah
Hi..my name if Fiza a.k.a Peah..I have involved in the software development world for almost 10 years now. I do freelance once in a while to keep up with the technology and I can be labeled as a free-thinker in the IT world..I did vb6, asp, php..involved in several databases mysql, postgresql, sql server...currently i am kinda in tact with oracle..Of all the above, I have deep interest in manipulating triggers, packages, functions, stored procedures...in any required dbms...and I also found that MOSS is fun to be discovered..
Usually works closely with a team of developers and gets more involved in design decisions, giving advice on performance and writing good SQL. That can be satisfying at a human level because you are part of a team and you share the satisfaction of the team's accomplishments.
Is responsible for maintaining Databases within an organisation, so it is a very difficult and demanding job. He or she, often gets involved when all the design decisions have been made, and has simply to keep things up and running.
Therefore, of course, it is also a rewarding job, both financially and in terms of job satisfaction. But it's a more 'lonely' job than being a Development DBA.
No comments:
Post a Comment