What happens when a table is created without defining columns? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 4

What happens when a table is created without defining columns?

Is it possible to define columns after just creating a table without defining it's columns (for example, "CREATE TABLE TABLE_NAME;")?

12th Mar 2019, 8:01 AM
Suraksha
1 Answer
+ 3
The SQL, CREATE TABLE statement requires column definition (it is not optional). So, the statement 'CREATE TABLE TABLE_NAME;' would not work. Here is the sql CREATE TABLE syntax: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-2017
12th Mar 2019, 8:36 AM
Ulisses Cruz
Ulisses Cruz - avatar