473,322 Members | 1,408 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

What fields are used?

Hi,

Is there a way in SQL Server, or Access to determine what fields are
being used in reports or joins, etc?

Scenario:

Field A in Table 1 is going to be either deleted or change data types,
and I'd like to know what impact that will have.

Yes...No?

Thanks,
Bodi
Jul 20 '05 #1
2 1269
Hi

This will usually depend on how your reports are being generated. If you
are using stored procedures to generate the data for the reports then
sp_depends may go some way to highlighting the procedure where it is used,
but overall you should still search the source code for all occurrences
either using a decent editor with a search function or manually. If your
code is in a version control system this sort of task is usually not as
painful!! Having a model of your database would also be a very good idea as
this should help to show all the relationships your table has to others,
looking at the information_schema views TABLE_CONSTRAINTS and
CONSTRAINT_COLUMN_USAGE may help if the column is part of a Primary or
Foreign Key.

John

"Bodi" <az*****@hotmail.com> wrote in message
news:89**************************@posting.google.c om...
Hi,

Is there a way in SQL Server, or Access to determine what fields are
being used in reports or joins, etc?

Scenario:

Field A in Table 1 is going to be either deleted or change data types,
and I'd like to know what impact that will have.

Yes...No?

Thanks,
Bodi

Jul 20 '05 #2
az*****@hotmail.com (Bodi) wrote in
news:89**************************@posting.google.c om:
Hi,

Is there a way in SQL Server, or Access to determine what fields are
being used in reports or joins, etc?

Scenario:

Field A in Table 1 is going to be either deleted or change data types,
and I'd like to know what impact that will have.

Yes...No?

Thanks,
Bodi


(s/field/column/g to appease Mr. Celko.)

Given that reports are something that a client creates, there's no way SQL
Server can report on what columns are used by a report.

The "Generate SQL script" function of SQL Enterprise Manager can be told to
include dependent objects, which means that if you generate the script for
Table 1, you can also get all tables and views that depend on table 1.

If you put a trace on your server, you can catch all statements issued
against a particular table or column. Or, you could add a trigger to your
table that could catch all inserts/updates/deletes against it. Not
selects, though, I don't think. Trace would seem to be your only option
there.
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Paul Morrow | last post by:
I have seen the technique where a number of rows in a database are displayed in an html table so that each column of each row is editable. They use a single form surrounding the table, where each...
2
by: Darryl Kerkeslager | last post by:
As the subject above hopefully makes clear, I want to do several reports, "with lots of fields not otherwise in database". These reports also have variable-length text. I have defined the...
35
by: wilsonidv | last post by:
Daer All: I have studied C language for just 2~3 months. I'd like to know the critical parts of C, focusing on these. Could anyone has many experiences tell me, please. Thanks and Regards.
4
by: John Dann | last post by:
I'm learning VB.Net with a view to converting from VB6. One simple detail I'm unsure of concerns fields (as class members). In VB6 I'd thought that declaring a class property just as a public...
32
by: Stephen Horne | last post by:
I've been using Visual C++ 2003 for some time, and recently started working on making my code compile in GCC and MinGW. I hit on lots of unexpected problems which boil down to the same template...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.