Advertisements
Create a table in MySql and Sql Server
Create table <table name> (
<column 1> data type,
<column 2> data type )
As an example, let’s create an employee table with 3 columns, ID, Name, and Date of Birth
create table Employee(
Id int,
Emp_NM varchar(255),
DOB date);
** remember that unless you set your database to be case sensitive, most SQL databases are not
You may need to refresh your database explore view, but after running this command, you should now have a new table
If you need a reference table for the types of data types available, check out this page: data types