SQL Server Transact Basic to Expert - Create Table Query

SQL Server Transact Basic to Expert - Create Table Query

This blog show how to create a table using the create table query. Creat table query is used to create a table with the required columns with the respective data types.

Syntax:

Create Table databasename.TableName
(Column1 Datatype, Column2 datatype etc..)

Example:

Create table emptable
(empid int, empname varchar(50), empsal int)