Nov 24, 2010

Sql Syntax

How can we create table

Example:
         
Table:- Flight_Master:


Column name
DataType
Length
Airlines_code
char
5
Airlines_ name
nvarchar
max
     

Select your database

Syntax:
use <database_name>  

USE AIRLINES    

CREATE TALE  <table_name>(<column_name> <Data_Type>)

 CREATE  TABLE  Flight_Master (Airlines_Code char(5), Airlines_name nvarchar(max))

Then Press F5

Command(s) completed successfully.

Table has been Created.

No comments:

Post a Comment