Header Ads

Creating a New SQL Database

sql lesson


Creating a New SQL Database



create database your database name

create table table name (

Type the column names and data types you want to create here.

Close the brackets after the last column and data type.)

For Exaple;


create table School (

StudentID varchar (4),
StudentFirstName varchar (12),
StudentLastName varchar (20),
StudentAddress varchar (40))


In this way you can create new database and table in sql.

No comments

Powered by Blogger.