Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
Queries
How to select all column values from table in sql How to rename the column in SQL How to create table in SQL How to add a new column to table in SQL How to change the data type of the column in SQL How to delete/remove column from table in SQL How to remove/delete the column(truncate) values from Table in SQL
Queries [cont'd]
How to delete table from database in SQL How to use select command in SQL How to add default value to the column in SQL How to add current system date and time to the column in SQL How to insert the values to the table columns in SQL How to create primary key to column in SQL How to create the foreign key for column in SQL
Queries [cont'd]
Referencing a foreign key to the primary key of the same table How to select the maximum value from sql column How to create a column with auto increment in sql server Identity column in sql server example Where condition in sql query And query in sql server Not like query in sql server
Queries [cont'd]
Or and and condition in sql server Like in sql server Using like and in sql together Subquery in sql server example Distinct in sql server example Having clause in sql server examples Count in sql server example
Queries [cont'd]
Truncate stored procedure sql server Create table in stored procedure sql server Delete / drop table in stored procedure sql server
How to create table in SQL in Queries of SQL Queries
2834 Views
Hints 
create table used to create table in database.Table has columns and rows structure.When creating a table given parameters are table name, column names and its datatype, size of the column.

In the following example you can able to see the parameters.Data types -int,nvarchar,varchar,datetime,double etc..,
Syntax
create table tableName(
columnName1 dataType(size) null(or) not null,
columnName2 dataType(size) null(or) not null,
columnName..n dataType(size) null(or) not null);
Example
Create the tables Customers and Orders with the following columns.
(do not declare the corresponding primary and foreign keys)

create table Customers(
Customerid char(5) not null,
CompanyName varchar(40) not null,
contactName char(30),
Address varchar(60),
City char(15),
Phone char(24),
Fax char(24));
create table Orders(
Orderid int not null,
CustomerId char(5) not null,
Orderdate datetime,
Shippeddate datetime,
Freight money,
Shipname varchar(40),
Shipaddres varchar(60),
Quantity int );
Previous Topics
Previous lessons of current book.
Queries of SQL Queries
Queries of SQL Queries
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details