SQL CREATE TABLE


SQL CREATE TABLE:
This statement is used to create table in a database.

 Syntax:
create table "tablename"  
("column1" "data type",  
"column2" "data type",  
"column3" "data type",  
...  

"columnN" "data type");  



Let us take an example to create a EMPLOYEE table with ID as primary key and NOT NULL are the constraint showing that these fields cannot be NULL while creating records in the table.

EX:


SQL> CREATE TABLE Employee (  
ID INT                                       //NOT NULL,  
NAME VARCHAR (20)             //NOT NULL,  
AGE INT                                   // NOT NULL,  
ADDRESS CHAR (25),  
PRIMARY KEY (ID)  
);  




You can check it, on the off chance that you have made the table effectively by taking a gander at the message showed by the SQL Server, else you can utilise DESC order as takes after: 

 SQL> DESC  EMPLOYEE;

Comments

Post a Comment

Popular posts from this blog

Difference between DROP,TRUNCATE and DELETE

The difference between TRUNCATE , DELETE and DROP   TRUNCATE TRUNCATE is a DDL command TRUNCATE is executed using a table lock and whole table is locked for remove all records. We cannot use Where clause with TRUNCATE. TRUNCATE removes all rows from a table. Minimal logging in transaction log, so it is performance wise faster. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log. Identify column is reset to its seed value if table contains any identity column. To use Truncate on a table you need at least ALTER permission on the table. Truncate uses the less transaction space than Delete statement. Truncate cannot be used with indexed views. DELETE DELETE is a DML command. DELETE is executed using a row lock, each row in the table is locked for deletion. We can use where clause with DELETE to filter ...
Read more