Tutorial by Examples

The DROP TABLE command remove the table definitions and all data, indexes, triggers, constraints and related permissions. Before you drop a table, you should check if there are any object (views, stored procedures, other tables) that reference the table. You cannot drop a table referenced by anoth...

The DROP DATABASE command removes a database catalog, regardless of its state (offline, read-only, suspect, etc.), from the current SQL Server instance. A database cannot be dropped if there are any database snapshots associated with it, as the database snapshots must be dropped first. A database ...

In SQL server we have 2 types of temporary tables: ##GlobalTempTable is a type of temporary table that is sheered between all user's sessions. #LocalTempTable temp tab - it is a type of temporary table that only exists in current scope (only in actual process - you can get id of your current pro...