A table named realizations should be created. As the name of the File there should be a mother-in-law date (I’ll get the current date value through Visual Studio c #). How to save a table file with the name I need if the table in the database should be called realizations?

    2 answers 2

    You can first create a table with the desired name. The file will have the same name as the table you are creating.

    Create Table 12092016 (record_code int(5), item_name char(50), price numeric(9), items_number int(5), money_amount int (12), record_date date)

    After that, you can rename the table and set the name of the table you need in the database. The database table file will have the same name, but in the data schema the name of the table will change.

     RENAME TABLE 12092016 TO tabletable

      The tables are free and included in the database. For tables included in the database, you can specify two names. One is entered in the Create dialog box, and the second is entered on the Table tab of the table constructor window. The name entered in the Create dialog box when creating a table is the name of the file in which the table is saved to disk.

      • I need to do this through a request - Ivan Hanenko