Top "Create-table" questions

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

Postgresql Create Table Fieldname Timestamp with Time Zone UTC

What is the syntax for creating a table with a field with the UTC time zone? I have for the …

postgresql timestamp create-table
Grant CREATE TABLE permission to MySQL User

I have a database that is shared between some users, and I want to manage their permissions on this. I …

mysql permissions create-table grant
Destroy and recreate a jQuery Datatables

I have two jQuery datatables with server side processing. I have a checkbox where I hide and show the two …

jquery datatables create-table destroy
phpMyAdmin and SHOW CREATE TABLE

Is there a shortcut in phpMyAdmin to SHOW CREATE TABLE for a table (i.e. a button I can click …

phpmyadmin shortcut create-table
SQL create table and set auto increment value without Alter table

For example I am creating the following table: CREATE TABLE Persons (      ID int NOT NULL AUTO_INCREMENT,      LastName varchar(255) NOT …

mysql create-table
How to create and populate a table in a single step as part of a CSV import operation?

I am looking for a quick-and-dirty way to import CSV files into SQL Server without having to create the table …

sql-server sql-server-2000 bulkinsert create-table openrowset
How do I create a table with self-referencing fields in MySQL?

In GTFS, the field parent_station is either from stop_id (self-reference) or NULL. For instance (note that parent_station …

mysql foreign-keys create-table self-reference gtfs
How to create table if not exists with HSQLDB

I'm using HSQLDB for persisting a small data, in my query I want to create tables at first time and …

hsqldb create-table
"Create table if not exists" - how to check the schema, too?

Is there a (more or less) standard way to check not only whether a table named mytable exists, but also …

sql database h2 create-table
Do I need to create separate index for primary key of relational database table

If I create table with primary key is index automatically created for the table or does that need doing separately. …

database indexing derby create-table