Basic operation CREATE , INSERT, UPDATE and DELETE in SQL.

Question

Basic operation CREATE , INSERT,  UPDATE and DELETE in SQL.

Abhishek Srivasatava · Answer

How to create table? Table can be form by 2 ways: Programming method and manual method. Programming Method 2nd method is the manual method. You need to follow following step. Under database -&gt; under Table section right click on table point to new table.Name the Column Name like ee_intn_id etc, datatype, check or unchecked the ‘Allow Null’ column. Save the table.For putting constraint on your table read this Cluster and non-cluster index in SQL and Different types of Constraints in SQL. How to insert data into the table? Below is the syntax to insert. How to Update data into the table? Below is the syntax to Update. How to delete the data from the table? Below is the syntax to Delete:

interview

Basic operation CREATE , INSERT, UPDATE and DELETE in SQL.

Can you answer this question?

1 Answers