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
See if the column names of all tables could be used to link them up
into a entity-relationship diagram... If not, you would have to read
the source codes to find out. You might also try creating new records
in each part of the systems using special descriptions, then find them
in the tables.
On
On Tue, Apr 7, 2015 at 8:50 AM, Jeff Johnson j...@san-dc.com wrote:
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
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
On 07/04/2015 19:57, Stephen Russell wrote:
On Tue, Apr 7, 2015 at 8:50 AM, Jeff Johnson j...@san-dc.com wrote:
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
On Sun, Apr 5, 2015 at 6:12 PM, Ted Roche tedro...@gmail.com wrote:
Matt's answer works.
Or you can use the VFP call SQLTables() to get a list of tables, then
loop through there, executing SELECT COUNT(*) FROM {tablename} to get
the record counts.
This was
Trouble will connection string for 2014. Here is what I am using and I
am not connecting:
'{Sql Server Native Client 11.0}, Server=192.168.1.115,
Database=ABEL_PROD, Trusted Connection=Yes'
I think this may be for 2012 and doesn't work for 2014.
What is the connection string for 2014. It
In Services it shows MSSQLSERVER in parenthesis. Is this the instance?
Where do I put the IP\SQLEXPRESS? In the (localdb)?
On 4/6/2015 7:31 AM, Stephen Russell wrote:
On Mon, Apr 6, 2015 at 9:21 AM, Jeff Johnson j...@san-dc.com wrote:
Trouble will connection string for 2014. Here is
Thanks Stephen.
Sent from my T-Mobile 4G LTE Device
Original message
From: Stephen Russell srussell...@gmail.com
Date:04/06/2015 08:06 (GMT-07:00)
To: profoxt...@leafe.com
Subject: Re: [NF] SQL Server Question
On Mon, Apr 6, 2015 at 9:49 AM, Jeff Johnson j...@san-dc.com
On Mon, Apr 6, 2015 at 9:49 AM, Jeff Johnson j...@san-dc.com wrote:
In Services it shows MSSQLSERVER in parenthesis. Is this the instance?
Where do I put the IP\SQLEXPRESS? In the (localdb)?
-
The connection string is a compound using a ; as a separator for each
entity.
On Mon, Apr 6, 2015 at 9:21 AM, Jeff Johnson j...@san-dc.com wrote:
Trouble will connection string for 2014. Here is what I am using and I am
not connecting:
'{Sql Server Native Client 11.0}, Server=192.168.1.115,
Database=ABEL_PROD, Trusted Connection=Yes'
---
On Sun, Apr 5, 2015 at 1:37 PM, 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?
For example, out of 1025 tables there are only
Matt's answer works.
Or you can use the VFP call SQLTables() to get a list of tables, then
loop through there, executing SELECT COUNT(*) FROM {tablename} to get
the record counts.
On Sun, Apr 5, 2015 at 2:37 PM, Jeff Johnson j...@san-dc.com wrote:
Gang, this SQL Server I was talking about the
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?
For example, out of 1025 tables there are only about 75 - 100 that have
pertinent data in them. Can I do a query to
For example, out of 1025 tables there are only about 75 - 100 that have
pertinent data in them. Can I do a query to tell me which ones have data?
Found these links that should help:
http://stackoverflow.com/questions/9954775/script-that-provides-the-row-counts-and-table-names
15 matches
Mail list logo