Top "Create-table" questions

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

SQLite Foreign Key

I'm following the instructions from the SQLite documentation at http://www.sqlite.org/foreignkeys.html however my attempt to add …

android sql sqlite foreign-key-relationship create-table
CREATE TABLE AS with PRIMARY KEY in one statement (PostgreSQL)

Is there a way to set the PRIMARY KEY in a single "CREATE TABLE AS" statement? Example - I would …

postgresql primary-key create-table
create SQL Server table based on a user defined type

I have my defined table type created with CREATE TYPE dbo.MyTableType AS TABLE ( Name varchar(10) NOT NULL, ValueDate date …

sql sql-server create-table
Create a temporary table from a selection or insert if table already exist

What is the best way to create a temporary table, if it does not already exist, and add the selected …

postgresql create-table postgresql-8.4
What does regclass signify in Postgresql

I have the following line in a CREATE TABLE statement: field1_id bigint DEFAULT nextval('table1_field1_id_seq'::regclass) …

postgresql create-table
SQL Server - Can you add field descriptions in CREATE TABLE?

I can see plenty of posts about where the field description extended property lives and how I can get it, …

sql sql-server create-table field-description
postgresql syntax error when creating a table

Hey everyone I need some help with creating tables. I have the script below and it creates a few tables. …

sql postgresql create-table
How can I add a foreign key when creating a new table?

I have these two CREATE TABLE statements: CREATE TABLE GUEST ( id int(15) not null auto_increment PRIMARY KEY, GuestName char(25) …

mysql create-table
HIVE - INSERT OVERWRITE vs DROP TABLE + CREATE TABLE + INSERT INTO

I'm doing some automatic script of few queries in hive and we found that we need time to time clear …

hive hiveql create-table
How do I alter my existing table to create a range partition in Oracle

I have existing table which has 10 years of data (I have taken dump). I would like to Range partition the …

oracle create-table alter-table partition