Create Table in a Database

I want to create a table in a database and insert queries into it as a part of weekly reporting.

Can this be done using AssistEdge?

Database Applications - for Automation of CRUD scenarios in Database.

Refer Link for More details -

Hi @Mantri

To automation database

  1. Create Database Application where you need to pass database details to connect with database
  2. Use Execute Database Query activity to execute your query/stored procedure

Hi @sumit.sagar and @bhuvan

I am getting the below error while passing the query - Query cannot contain keywords create, update, delete, alter drop


Hi @Mantri

Create a stored procedure to perform DML and DDL operation.