Must be happy
It's my space
Wednesday, December 11, 2013
刪除 User 下的所有 Table 的方法
刪除 User 下的所有 Table 的方法
A. 使用下面語法產生 Drop 的 sql script
select 'drop table '||table_name||' cascade constraints;' from user_tables;
B. 將Drop Script 執行
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Blog Archive
►
2014
(2)
►
April
(2)
▼
2013
(3)
▼
December
(1)
刪除 User 下的所有 Table 的方法
►
January
(2)
►
2012
(3)
►
July
(1)
►
June
(1)
►
March
(1)
►
2011
(5)
►
August
(1)
►
May
(1)
►
March
(1)
►
February
(1)
►
January
(1)
►
2010
(2)
►
October
(1)
►
April
(1)
►
2009
(10)
►
October
(1)
►
June
(3)
►
May
(1)
►
April
(1)
►
March
(2)
►
February
(1)
►
January
(1)
►
2008
(3)
►
July
(3)
About Me
Freak
View my complete profile
Taro
Taro
Subscribe This blog
Posts
Atom
Posts
All Comments
Atom
All Comments
站長統計工具