Question

Locked

I Need some SQL Help!

By cupcake ·
Hey all... fairly new to SQL and to this new company. They've asked me
to validate data for a feature of the software by comparing raw data to
what's being written into the table.

The problem? No one is sure what the name of the table is! The
person I took over for left no notes and was apparently the "expert"
(which means he left with his 'secrets') on this particular set of data.

Someone thought the table included the word "effective", but this
particular application has too many table to search through one by
one. Is there a query or a way to look for this word in a table name?

Thanks in advance to whomever can help!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

SQL .How to validate data. Hope this helps you.

http://msdn.microsoft.com/en-us/library/ms147366.aspx

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.

Collapse -

If it's SQL Server

by Tony Hopkinson In reply to I Need some SQL Help!

you want the SQL Server Profiler.

You can collect all sorts of stuff but it will tell you what queries are running in the server, may help you find the code as well.

As for the query.

Select * From SysObjects where [Type] = 'U' and [Name] like '%effective%'

Something like that anyway...

Collapse -

Which DBMS are you using ?

by simon In reply to I Need some SQL Help!

Hi. If this is a MySQL server then simplest way is to do a backup and dump the schema. You can use phpMyAdmin (web based admin tool) or the MySQL GUI tools to do a backup of the db (run MySQL Administrator) and then do a text search through the downloaded SQL file for the name you are after. You can also use the MySQL command line programme mysqldump and specify the --no-data option to create a file with no records in it, just the schema design. Again, search through it using a text editor or similar.

There are similar functions available with MS SQL Server, Sybase and PostgreSQL - either using the command line or GUI tools (e.g. Enterprise Manager with SQL Server or phpPgAdmin for PGSQL.)

Hope that helps.

Related Discussions

Related Forums