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
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