Wednesday, February 15, 2012

How to create table in SQL Server

Now we are going to create Table for the previous DataBase "myalbum" as menctioned in the previous post
i.e.,  How to create database in sql server
Create a table in sql server as shown below...

The SQL syntax for CREATE TABLE is




CREATE TABLE "table_name"
(
"Column 1" "data_type_for_column1",
"Column 2" "data_type_for_column2",
"Column 3" "data_type_for_column3",
"Column 4" "data_type_for_column4",
..........
"Column N" "data_type_for_columnN",
)

Example :-

Previously we created DB as myalbum

No comments:

Post a Comment