Hi Guest

MobileUser

1 HomePage 1 Jobs 1 WalkIn 1Articles  

Cat Exam

 :) Latest Topic
general knowledge
ASP.NET
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
 AngularJS
 :) Hot Jobs
 
 :) Latest Articles


  

 


SQL Syntax
Question Posted on 23 Oct 2019

Home >> Tutorial >> SQL >> SQL Syntax




SQL Syntax
There are some unique set of rules and guidelines which are called syntax in SQL. Below are the basic SQL syntax.
-SQL is not case sensitive and SQL keywords is generally written in uppercase.
-We can perform most of the action in database with the help of SQL statements.
-SQL statement are basically dependent on text lines and we can place a single SQL statement on one or multiple text lines.
-SQL basically depends on relational algebra and tuple relational calculus.


Now something about SQL statement
SQL statements are started with SQL commands or keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP etc. and all the SQL statement ends with semicolon.

SELECT "column_name" FROM "table_name";

Now question raise why we use semicolon after SQL statements:

We used semicolon to separate SQL statements. It is called standard way to separate SQL statements. And by adding semicolon we can add more then one query in sql statements.

Now come to SQL Commands

Below are the some important SQL command:

SELECT: it used to get data from a database.

UPDATE: it used to updates data in database.

DELETE: it used to deletes data from database.

CREATE TABLE: it is used creates a new table.

ALTER TABLE: it is basically used to modify the table.

DROP TABLE: it is used to delete a table.

CREATE DATABASE: it is used to creates a new database.

ALTER DATABASE: It is mainly used to modify a database.

INSERT INTO: It is used to insert new data into a database.

CREATE INDEX: It is mainly used to create an index (search key).

DROP INDEX: It is used to delete an index.
0
0



 
 Input Your Comments Or suggestions(If Any)
 Name
 Email(optional)
 Comments


Other Important Questions
SQL Tutorial
Introduction to SQL
RDBMS VS DBMS
SQL Syntax
SQL Data Type






 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |