Micros DB Tables

[michelle305]

Using Sybase for a 3700 Micros.
How to look up all tables in interactive sq??? Using select * from sysobjects where type ="U" I am missing some _def and _dtl and I assume because of the type value. But when I remove that variable does not seem to alter results.

Thanks

 

[pmegan]

If you just want to list the tables use

select * from sys.systable

I'd suggest using Sybase Central though. It should be right under Interactive SQL in the start menu on your server. Click the connect icon, enter your SQL username/password, and you can list all of the tables, views, stored procedures, etc... The nice thing is that if you expand the Tables tree on the left and select a table, you can see all of the columns for that table on the right, as well as the primary/foreign keys and all the other tables it's linked to.

 

[michelle305]

So micros is the database.
sys.systable (or Sybase) gives me individual tables in micros.db but Sybase also gives me the COLUMNS in the individual
tables.

A lot of these tutorials you see are confusing- they never have tables listed as XXXX_dtl or XXX.cfg. Only one word for the TABLE??? Is that due to different standards of sql?

 

[pmegan]

I think you're mixing up a few things.

[ul]
[li]micros.db is the actual database file[/li]
[li]micros is the logical name of the database, as well as the ODBC connection name[/li]
[li]It's a little confusing at first, but once you realize that there are 3 distinct entities named "micros" it makes sense for consistency.[/li]
[/ul]

[ul]
[li]Sybase is the database system, similar to Microsoft SQL Server[/li]
[li]Sybase Central is an application for displaying and modifying database object, similar to SSMS (SQL Server Management Studio)[/li]
[/ul]

[ul]
[li]The "xxx." before a table name shows what database account owns or created the table.[/li]
[li]Tables starting with "sys." are standard system tables used by the database engine to keep track of the database objects. You can use these to list tables, users and procedures.[/li]
[li]Tables, procedures, views and functions starting with "micros." are specific to the micros database.[/li]
[/ul]

You won't see xxx_dtl or xxx_cfg tables in SQL tutorials online. Those all belong to the "micros" user account, therefore they're specific to the micros database. Anything online will be as generic as possible. You won't be able to find the exact query you need online, they're made to show the concept behind managing and manipulating a database so you can apply those concepts to the database you're using.

 

[michelle305]

Thank you again for explaining things better than books and coworkers.....