SQL Server

Drop Table in SQL Server

in SQL Server we use the drop table statement to delete a table & data stored in it from the database. We can also drop the multiple tables in a single query.

Fully Qualified Table Names in SQL Server

The fully qualified table names in SQL Server consists of three parts. database name, schema name & the actual table name. The fully qualified table name must be UNIQUE in a SQL Server instance. We learned how to Create tables in the previous tutorial.

Create Table in SQL Server

In this tutorial, we learn how to Create Table in SQL Server. We can create Tables either using the Create Table statement or using the Table designer option in SSMS. We learn both of these methods of Creating the SQL Server tables in the tutorial.

Scroll to Top