Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-06 : 21:15:49
|
Erkan writes "I tried the following script
begin
for a in (select table_name from
user_tables)
loop
insert
into bad_tables
(anzahl, tabelle)
select count(*) as anzahl,
a.table_name
from user_Tables x
where a.table_name=x.table_name;
end loop;
end;
/
but it dont func, can anyone help me ?" |
|
|
|
|
|
how can i see the count of all tables, ordered by tablename ?