Create a Table in SQL
SQL ( Structured Query
Language ) is widely used language and it is used mostly with RDBMS (
Relational Data Base Management System ). In the beginning the name of SQL was
SEQUEL Structured English Query Language. The main work of SQL is to bring,
update and remove the design in database. Another important thing about SQL is
that you can use it in any database software system like MYSQL, Microsoft SQL
and Oracle Database etc. SQL has many commands and some are common and most
useful like “ Select ”, “ Insert ”, “ Update ”, “ Delete ”, “ Create ” and “
Drop ”. CLICK HERE TO KNOW Create a Dropdown List in Excel using Data Validation ...
 |
| Add a SQL Structured Query Language Table |
Syntax for SQL Table :
CREATE TABLE table_name
(
Column_name1 data_type (
size ),
Column_name2 data_type (
size ),
Column_name3 data_type (
size ).
…….
) ;
In this syntax,
column_name is used to show the name and data_type represents the types of data
like varchar, integer, decimal, date etc, where the Size belongs to the maximum
length of table.
Example of SQL Table :
CREATE TABLE employee1
(
First varchar ( 15 ),
Last varchar ( 20 ),
Age number ( 3 ),
Address varchar ( 30 ),
City varchar ( 20 ),
State varchar ( 20 ),
) ;
 |
| How to Create Table in SQL |
Type of Data :
Chart ( Size )
|
You have a fixed limit to write
letter, with that you can only use 225 bit of data as well.
|
Varcahr ( Size )
|
In varcahr size the limit of
letter is different, with that the maximum size is also not fixed.
|
Number ( Size )
|
As the name shows we uses number
and mathematical signs in it. It also has a maximum limit of size.
|
Date
|
Here you enter the value of date.
|
Some Important Things
Related to SQL :
- Whenever
you names a table then remember the name must be different from others, so no
one can use your table.
- You
can add your date of birth in the name of table or other secret number also.
- Drop
your table after creating any SQL table.
TO KNOW MORE ABOUT ADD A
SQL STRUCTURED QUERY LANGUAGE TABLE, IMMEDIATELY COMMENT US BELOW AND GET FAST
INSTANT REPLY. THANK YOU.
 |
| Structured Query Language |
How to Create Table in SQL, SQL Table Statement,
Structured Query Language Table, SQL Table, Insert Values into SQL table, Syntax
for SQL Table, Example Data Type of SQL Table, How to Name SQL Table
YOU MAY ALSO LIKE : -
- Add a SQL Structured Query Language Table
- Working and Functioning of Graphic Processing Unit GPU Card
- Which Type of Graphic Card Do I Need Explain
- Install a Graphic Card GPU in Just 5 Minutes
- Advantages and Disadvantages of Graphic Video Gaming Card
- Prepare Pan Pizza on Stove without Oven at Home
- How to Make Really Good Homemade Delicious Pizza
- Miraculous Healing Medicine Power Qualities of Eating Grapes
- Compelling Signs Your Soul Has Reincarnated Again
- Full of Nutrients Minerals Sour and Sweet Green Black Grapes
- Aayurvedic Remedies to Cure Pyorrhea Teeth Diseases
No comments:
Post a Comment