|
查看所有约束 |
select table_name, constraint_name from user_cons_columns where table_name='TB_STUDENTS'; |
查看当前用户下所有同义词 |
select * from user_synonyms; |
查看当前用户下的所有索引 |
select index_name from user_indexes; |
查看当前用户下所有视图 |
select view_name from user_views; |
查看当前用户下所有序列 |
select * from user_sequences; |
查看当前用户下所有表 |
select table_name from user_tables |
查看当前用户下所有触发器 |
select trigger_name from all_triggers where table_name=''; |
存储函数和过程 |
select object_name,status from user_objects where object_type='FUNCTION'; |
select object_name,status from user_objects where object_type='PROCEDURE';
|
Oracle查看命令
最新推荐文章于 2023-09-21 22:23:18 发布