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

Опубликовано: 09 Март 2026
на канале: Right to Learn @BK

8,316

130

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
SP_RENAME 'table_name.old_column_name','new_column_name'

Rename Table
exec sp_rename 'schema.old_table_name', 'new_table_name'

DROP TABLE table_name