Create a table is a function of Sheetkraft which helps in creating a table in a database. This can be achieved with the help of database explorer. The following guidelines explain how to create a table:
On SheetKraft ribbon, click on the Database Explorer tab.
Select the Database Type as SqlServer
Connect to the relevant data source by inserting the connection string which can be created by
a) Go to Import from Database tab.
Select the data range, for which table structure is needed to be constructed.
Click on Infer Columns (SheetKraft will read and interpret relevant details), make the relevant columns primary key and tick the column which can be nullable.
Data types are -
Provide the Schema and Table name and then click on Generate SQL
After this, in the same UI click on the SQL tab below the Connection String bar and in that click on Run Non-Query.
Run Non-Query/Run Query
A query is something that returns one or more row sets.
Select * from TABLENAME is a query that returns a single row set.
create table ... is not a query. It doesn't return tabular data.
Run Query runs a query and shows the result as a table whereas Run Non-Query executes the SQL and neither expects nor displays a result.
Query is executed successfully and your table is created in the database.