About SQL Basic Features


How to create a table in SQL Server

Tables are objects in database that hold all the data in a database. In tables, data is logically structured in a column and row format. Each column represents a name of the header or a field in the record and each row represents a unique record.

How to drop table in SQL Server

The DROP TABLE statement is used to drop an existing table in a database. In other words, you can delete any exiting tables in a database. It will delete the definition of table, all the data, indexes, triggers, constraints and permission for that table.

How to rename table in SQL Server

You can not rename any existing table directly in a database. To rename a table, sp_rename is a built-in stored procedure which help us to rename any existing tables in the SQL Server.