Man-wai, actually I am going to use VFP to scan the tables and see which
ones of them have data in them. Out of 1025 tables, very few are used.
This is the most bizarre database structure I have ever seen. Nothing is
stored in the primary table except foreign keys to tables. There is a
name table, eye color table, hair color table, etc.
It was developed by a non-programmer and they kept working on it until
they sold it as a commercial application. It is very expensive also.
On 4/7/2015 4:08 AM, Man-wai Chang wrote:
You talking about Information Schema?
https://msdn.microsoft.com/en-us/library/ms186778.aspx
On Mon, Apr 6, 2015 at 2:37 AM, Jeff Johnson <j...@san-dc.com> wrote:
Gang, this SQL Server I was talking about the last few days appears to have
1025 tables! My question, is there a way to query the database to see how
many records a table has?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5523e091.8080...@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
