Create Table in SQL - Insert data, Add/Delete column, Rename coulmn and table || Ms SQL

preview_player
Показать описание
In this video I have shown how to :
Create Table in a Database
Data types in SQL
Insert data into a Table
Modify existing Table (add/drop columns and change datatype of columns)
Drop and truncateTable

CREATE TABLE table_name 
(column1 datatype, column2 datatype, column3 datatype, ....
....);

INSERT INTO table_name (column1, column2, column3,...)VALUES (value1, value2, value3, ...);

INSERT INTO table_name VALUES (value1, value2, value3, ...);

Add column
ALTER TABLE table_name ADD column_name datatype

Change datatype of a column
ALTER TABLE table_name ALTER COLUMN column_name datatype

Drop column
ALTER TABLE table_name DROP COLUMN column_name

Rename column

Rename Table

DROP TABLE table_name
Рекомендации по теме
Комментарии
Автор

Sir what is the difference between char vachar how to use them...?

yousufjamal