建立同义词。
CREATE [PUBLIC] SYNONYM synonym_name FOR object; |
DROP SYNONYM synonym_name; |
参数 | 描述 |
---|---|
synonym_name | 同义词名 |
PUBLIC | 可被所有用户存取 |
SELECT ic.index_name, ic.column_name, ic.column_position col_pos,ix.uniqueness FROM user_indexes ix, user_ind_columns ic WHERE ic.index_name = ix.index_name AND ic.table_name = 'table_name'; |