Menu
The create database statement is:
CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, .... ) But I'm wondering how can I create a table in a specific database?
588
The easiest way is by right click on table A from database temp , then click Script Table as => CREATE to => New Query Editor Window . This will create the script. Then, change following 2 lines. and run it for new database.
Creating Tables in a Database There are several ways to create a new table: in Datasheet view, in Design view, with Table Templates, SharePoint Lists, or by importing a table or linking to the data in a table from another Access database.
You can specify the DB Name in the same query:
CREATE TABLE database_name.table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, .... )
127
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
