Basic SQL Database understanding

[moezsajwani]

Hi All,

I am trying to connect Power BI with SQL server for retail POS system. It's a vendor built system so I have no or very limited knowledge about the system architect. I have basic understanding about databases and wondering if someone can help me understand the difference between image shown for VI* tables vs. AI* tables in below image. So far I have only seen the table image as shown for AI* databases. Can anybody here explain the difference to me? Thanks a lot in advance.

[Anonymous · Accepted solution]

Hi @moezsajwani,

According to your description, your requirement seems more related to SQL database.

I'd like to suggest you post to SQL Server related forum to get better support.

Msdn forums - SQL Server - Microsoft

Difference between View and table in sql

Regards,

Xiaoxin Sheng

[HotChilli]

The top 3 are views, the other 2 are tables