SQL Script : Adventure works database setup and Select query, list of tables #100daysofsql

Hi all, 

 Welcome to 100 days of SQL script code 

 In this blog post, will start with AdventureWorks sample database in Microsoft SQL server 

 Install MS SQL server and SSMS latest version

 Download bak file from https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

Follow the restore steps in the same above link

after restoring below adventure work database below 

Run the below query in SQL server

-- showing list of tables

select * from INFORMATION_SCHEMA.TABLES

 

output

 customer and product table select query

-- customer and product table 

select * from SalesLT.Customer

select * from SalesLT.Product

Outputs are