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.