Top "Create-table" questions

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

PostgreSQL Error: Relation already exists

I am trying to create a table that was dropped previously. But when I do the CREATE TABLE A ... I …

postgresql identifier create-table
Create hive table using "as select" or "like" and also specify delimiter

Is it possible to do a create table <mytable> as select <query statement> using row format …

hive sql-like create-table
C# - Create SQL Server table programmatically

I am trying to create a SQL Server table programmatically. Here is the code. using (SqlConnection con = new SqlConnection(conStr)) { …

c# .net sql-server create-table
How to create a table in a particular database?

The create database statement is: CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_…

mysql database create-table
How to create mysql table with column timestamp default current_date?

I need to create mysql table with default value on column CURRENT_DATE() I try DROP TABLE IF EXISTS `visitors`; …

mysql sql datetime timestamp create-table
CREATE TABLE permission denied in database 'tempdb'

First time I installed SQL Server Management Studio Express and Visual Studio 2005 on my system. Now I am trying to …

sql-server create-table
Is it possible to roll back CREATE TABLE and ALTER TABLE statements in major SQL databases?

I am working on a program that issues DDL. I would like to know whether CREATE TABLE and similar DDL …

sql transactions ddl create-table
Postgres table column name restrictions?

I did this in psql: CREATE TABLE IF NOT EXISTS apiss (skey TEXT, time INTEGER, user TEXT, ip TEXT); I …

postgresql create-table
MySQL - How to create a new table that is a join on primary key of two existing tables

I have two existing tables, with different fields, except for Primary ID (a varchar, not an int). I want to …

mysql join merge create-table
Alter table if exists or create if doesn't

I need to run an installer which can also be an updater. The installer needs to be able to end …

mysql alter-table create-table