What is the software tool for creating a sql script on an existing database?

Question

SQL

There is a database created in Visual Studio (localdb). It has a couple of tables with data.
How can you save in one sql script the creation of a database and filling it with data?
In Management Studio, I found the creation of a database and tables in the Tasks tab > Generate scripts, but it is necessary that data be added as well.

Answer 1

You haven't looked at all the settings
joxi.ru/KewyU_3JTJAPdAemdiw

Answer 2

try something like this
CREATE TABLE IF NOT EXISTS `actions1` (
`action_id` int(4) NOT NULL AUTO_INCREMENT,
`action_name` varchar(30) DEFAULT NULL,
PRIMARY KEY (`action_id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET= utf8;
INSERT INTO `actions` (`action_id`, `action_name`) VALUES
(1, 'actions'),
(3, 'registration'),
(5, 'index'),
(7, 'view'),
(11, 'index');