Top "Create-table" questions

The statement that creates a table in SQL (`CREATE TABLE ...`).

Create table if not exists syntax db2

I wish to write a SQL script that will check whether the table/sequence exists or not before create the …

sql database db2 create-table not-exists
create table with select syntax in mysql

i would like to know how mysql interprets the create table syntax: if i write: create table tbl1 ( `v1` int, `…

mysql sql select create-table
MySQL - Foreign key on delete set null in not null field

This is probably a trivial question, but I'm still a little clumsy when it comes to foreign key constraints so …

mysql sql foreign-key-relationship create-table notnull
How to export a data frame in R to a table in MySQL

I tried sqlSave() in RODBC, but it runs super slowly. Is there an alternative way of doing this?

mysql r dataframe create-table
What is the difference between UNIQUE, UNIQUE KEY and CONSTRAINT 'name' UNIQUE?

I have a basic users table I want to create in MySQL. I do not want duplicate emails or duplicate …

mysql database-design unique create-table unique-constraint
How to copy structure of one table to another with foreign key constraints in psql?

Foreign key constraints are not copied when using create table table_name ( like source_table INCLUDING ALL)' in Postgres. …

postgresql foreign-keys plpgsql create-table
Form has my table locked down tight even after docmd.close

Sorry for the wall of text guys but this one requires expliaining, way too much code to post... I'm importing …

ms-access locking create-table drop-table
Can ActiveRecord create tables outside of a migration?

I am working on a non Rails web app, so no migrations script by default. The Sequel ORM lets me …

database orm activerecord sql create-table
"Create table as select" does not preserve not null

I am trying to use the "Create Table As Select" feature from Oracle to do a fast update. The problem …

oracle create-table