Regular table Temporary table Table variable Derived table CTE View Table-Valued function The above said are the types of available tables in sql. I hope this article would be helpful.
Sometimes the exception "Table or object already exists" comes when we create a table . To avoid this issue we will have to check whether the table is already exists or not. I hope this article would be helpful. IF OBJECT_ID(N'dbo.Orders',N'U') IS NOT NULL DROP TABLE dbo.Orders;