Using the AI (artificial intelligence) assistant on Datasources, you can create a data table in seconds and get suggestions from the AI assistant for the data types in the table.
You can create a table via Custom Actions panel in UI Design view mode or with New Table under Datasources heading in Datasources view mode.
In general terms, the improvements we have made on the SQL Table creation modal are as follows;
Activate Generate with AI to be able to use the AI (artificial intelligence) assistant in the table creation process. The AI assistant helps to generate the data type for the table you want to create.
Name the data you want to be in the table and click enter. The AI assistant will suggest the data type. In cases where it cannot find the data type, it assigns the data type as String .
For example, to create a Personnel table, when we give a nomenclature as PersonnelName, the AI (artificial intelligence) assistant defines the data type as String. When you enter another data as Date of Birth, you can see that it defines DateTimeOffset data type.
Columns cannot be updated during the table update process. If you want to change the name and data type of a column, you must delete the column and create it again.
You can include each data you define in the table by clicking + Add and then create the table by clicking CREATE.