Creation and manipulation of tables using SQL,create table command




The CREATE TABLE statement is used to create a table in a database.

Syntax

CREATE TABLE <table_name>
(
<column_name1> <data_type>(<size>),
<column_name2> <data_type>(<size>),
....
);
Example
        create table stud(rollno number,name varchar(10),class varchar(5));



About the Author

Unknown

Author & Editor

Has laoreet percipitur ad. Vide interesset in mei, no his legimus verterem. Et nostrum imperdiet appellantur usu, mnesarchum referrentur id vim.

Post a Comment

 
My Study Voice © 2015 - Designed by Templateism | Distributed By Blogger Templates