Database Schema - Table or table names

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?

Reply to
ClothingStore
Loading thread data ...

Reply to
ClothingStore

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

Cloth> Yes, but does anyone know the command or select command to get a list of the

Reply to
Evan Culver

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.

Reply to
Jason Hunt

You could also try a graphical MSDE Management tool such as EMS SQL Manager Lite, which is free.

formatting link
EMS MS SQL Manager Lite (full installation package)1.8.5.2

07/11/2005 3.83 Mb
Reply to
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

Reply to
Robert

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.

Reply to
Jason Hunt

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

Reply to
root

have you tried using sp_help :)

Reply to
cosmicpinball

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.

Reply to
root

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...

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

Reply to
Antonio Mazzeo

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

Reply to
Rick Brown

Hey Rick,

I def> If you use Microsoft Access to link to the database using Get External Data

Reply to
Clinton Boyda

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.