March 23, 2017

Table data Backup steps from database in SQL Management Studio

How You  can take table backup in sql database There is simple way and step shown in below youtube clip.

1.Open SQL database engine and connect it.
2.let us You want to copy data of table custtable to  table custtable_bkp where custtable_bkp does not exist in your database.
3. This clip will show the step and will create new table with data of custtable .

4. In this clip select into statement used same way you can do the same using insert into command also but insert into used if table custtable_bkp already exist with structure only not data.

5. If you want to drop or delete table you can use this command.

drop table <table name>

Mow after execution  drop command table will be deleted..

Thanks for watching.

If you like it please subscribe