Database Schema - Table or table names


C

ClothingStore

Hello Everyone,
I was wondering if there was a list of all the tables in RMS somewhere. All
tables including any temp tables that are used. I am using a custom dll and
have my hooks in place, but I noticed in POS screen it seems the whole time
you are building a pos ticket with customer information and inventory
information nothing is really being saved to the database yet. Or not that
I can see any of the tables I have tried. So you have your screen full and
just before you hit tenderbegin it seems none of the work you have done so
far on the screen like customer information, inventory information has been
saved anywhere. Is this true?

Any ideas?
 
Ad

Advertisements

J

Jason Hunt

You're right, nothing is written to the database until you tender the sale.

As for a list of tables, just look at all the tables in the database.
Unforunately there's no map or anything which gives you the relationships.
There is an Excel spreadsheet on PartnerSource, but it is just a list of
tables and columns.

You can always use the SQL Profiler to figure out how the tables are used.
 
C

ClothingStore

Yes, but does anyone know the command or select command to get a list of the
tables? Does anyone have a copy of the excel partnersource spreadsheet as
mentioned?
 
E

Evan Culver

list of tables:

SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES
ORDER BY TABLE_NAME

list of tables and columns:

SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
ORDER BY TABLE_NAME

-
Evan Culver
New West Technologies
 
J

Jason Hunt

I think this is what you're looking for:

SELECT [name] FROM [sysobjects] WHERE xtype='U' ORDER BY [name] ASC

You can also pull out column names from the sysobjects table (xtype='D'),
but the names have prefixes and suffixes.
 
R

root

also, you could download the SQL Server 2000 trial and only install
Enterprise Manager with no timebomb :)
 
Ad

Advertisements

R

Robert

Root,

What do you mean 'with no timebomb'? I have have several of there software
installed on my computer and I have never had any probelms with any of them.
This company has been around for quite a while and has some pretty great
tools, maybe you should check them out before bashing.

Rob
 
R

root

Rob,

'with no timebomb' = with no expiration date

I am stating that a person, as another option, could download Microsoft SQL
Server 2000 TRIAL and only install the Enterprise Manager part of it.
Microsoft SQL Server 2000 TRIAL software has a "timebomb" (timed expriation
date when the software will quit working - hence the term TRIAL). If you
only install the Enterprise Manager part it will not be succeptable to the
"timebomb" (or timed expiration or TRIAL) and you will still be able to use
the GUI as you would be able to if you installed the full version of
Microsoft SQL Server 2000.

Many people think TRIAL software is not worth the time to download when it
is a package that large and they suspect they will not be throwing down the
$1500 in the end, but there is a benefit in this case.

By the way, I have checked out the software you have suggested as well as
about 6+ other MSDE Manager applications. Many of these other applications
are nice, including the one you had suggested, but I figure why pay $300
plus for a pro version or use a free watered down version with no basic
backup/restore/job features that are inherent in the MSDE architecture when
you can use the FREE MS Enterprise Manager that utilizes ALL of the inherent
MSDE features.
 
A

Antonio Mazzeo

ClothingStore said:
Hello Everyone,
I was wondering if there was a list of all the tables in RMS somewhere. All
tables including any temp tables that are used.
You can to have a list of all tables only through SQL PROFILER ... but
why? RMS POS use temp tables only to post data into db more fast...
I am using a custom dll and
have my hooks in place, but I noticed in POS screen it seems the whole time
you are building a pos ticket with customer information and inventory
information nothing is really being saved to the database yet.
No.. not in database, but in memory... the pos run with a COM object
that contain all data and methods to get/put from/into database..

bye bye
antonio
 
R

Rick Brown

If you use Microsoft Access to link to the database using Get External Data
and ODBC, you have a choice of Link or Import the tables. If you Link, it'll
ask you which tables and you select all. Then it asks for the primary key
for some of the tables it can't discern. Select ID as the primary key except
Transaction table - select Transaction Number. There are a few others with
no ID field like Movement tables which I don't choose a PK for.

When you're done, you have an access database live-linked to your SQL server
database tables and you can see all tables fields and attributes. You can
use Access Queries to manipulate data. It looks and works just like an
access database. One of my grocery clients is moving to a new building and
wanted to put all items on 20% sale excluding certain depts and items
containing certain criteria in SubDescr1, and the departments excluded in
the 20%sale to be set up for 30% sale. They want to sell as opposed to move
as much stock as possible. I used Access's visual, intuitive Query screen
to construct, test and update the sale prices, and date range, and check the
This Item on Sale box of 35,000 items from home over remote desktop last
night. I always attach Access to my installs and use it to analyze and
manipulate data.

I'm not that adept at SQL, so sometimes when I'm customizing an Active
Report for a client, I'll use Access's Query to visually construct the
logic, then click on View SQL to see the SQL code for what I just did and
paste it into the Active Report to modify it further there, but it gives me
the construct.

Is anyone else using Access with RMS? I don't think I've ever seen anyone
mention it. Especially if you're a database person come from a DOS database,
paradox, foxpro or access, you'd appreciate the simplicity of using Access
to manipulate and analyze RMS data.

Rick Brown
DataBasics
 
Ad

Advertisements

C

Clinton Boyda

Hey Rick,

I definately agree with using Access as a report too for RMS - would you be
able to email me the access database with linked tables?
(e-mail address removed)
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top