db2别名&同义词

创建别名:

create alias alias_name  for tab_name|view_name...

删除别名:

drop alias alias_name

创建同义词(synonym):

create synonym syn_name for ...
create public synonym syn_name for ...

删除同义词:

drop synonym syn_name
drop public  synonym syn_name

posted @ 2013-10-12 17:58  天之涯0204  阅读(2034)  评论(0)    收藏  举报