SQL

Question

I am new to SQL. I started learning to create table in MS SQL systems. When you write a script to create a table. Do we have to physically create a table? Also when we are adding a row in current table using how to do that because I do not see actual table just the script. Please help!!

Answer 1

You can imagine a database as a large file in the filesystem. The database engine knows how to read and write this file efficiently, and SQL is the language that lets us communicate with the database engine.

SQL is a declarative language. It means that we write our intention, of course in the correct syntax, which is very similar to a meaningful English sentence, and the database will execute it. The script, or SQL statement is the instruction, and you need not see the details how it ultimately changes the file system. After you CREATE a table and INSERT some lines, you can always SELECT to see the result.

Answer 2

Jay Matthews if you read properly my post. You will see where I was rude and obnoxious🤔🤔
I am new to a topic and seeking help.