#Database
Sybase SQL Anywhere query data count in every table
select table_name, count
from systable
where primary_root<>0 and creator=1
order by 1
Difference between View and Table in SQL
1. A table contains data, a view is just a SELECT statement which has been saved in the database.
2. The adventage of a view is that it can join data from several tables thus creating a new view of i