Ui path database

Learn Academy Feedback
1

can we create database and tables using ui path and how we can achieve it?

2

Yes you can using DataBase Activity, setting will be differ based on Which DataBase server you are using,
you can follow the Steps as suggested in the below link;

1 Like
3

Hi @Ruchi15,Yes you can create tables and database.You need to provide your db details and execute query

4

Hope this helps for Datatables and Data variables:

5

my question is that if we want to create database, table & then insert values in it i.e all through ui path activities(6 activities are there), then what would be the workflow?

6

“create database Try; use Try; create table Laptop(Name varchar(10), Price float(5))”

this is what i’m trying.

7
  1. Connect(provide your Connection string).
  2. Execute query (Write your Create table query).
  3. You can use either Insert activity or Execute None query(write insert query).
  4. Disconnect
8

(post withdrawn by author, will be automatically deleted in 24 hours unless flagged)