OK, so I'm just learning sql and I would like to be able to
create my own reports. I've looked over the sample reports and the
"How to create your own PDMWorks Enterprise reports" document.
Where I'm a little confused is how do I know what the tables names
and field names are?
Does anyone know if there is anything documented anywhere?
Thanks
Does anyone know if there is anything documented anywhere?
Thanks
That is where the SQL Server Management Studio is handy. You can browse the tables and relationships between the tables. It takes a while to familiarize yourself with the structure and where information is stored. (A bit like reverse engineering).
You can create an ER (entitiy relationship diagram) by using Visio 2003 (SP3) that is essentially a table map.
Joy