Top "Database-table" questions

In a relational database management system (RDBMS) a table organizes the information in rows and columns.

Table Scan and Index Scan in SQL

What is the difference between Table scan and Index scan in SQL and where it is used specifically?

sql database-table
Check if extended property description already exists before adding

So, I have a script that adds extended properties, some describing a table, some describing a column. How can I …

sql sql-server exists extended-properties database-table
MySQL Error 1 (HY000) Trouble creating file Errcode 2

I'm having issues creating a table for my ruby on rails app. It's driving me crazy! The following is returned …

mysql database-table
Limit an sqlite Table's Maximum Number of Rows

I am looking to implement a sort of 'activity log' table where actions a user does are stored in a …

database database-design sqlite database-table
T-SQL Pivot? Possibility of creating table columns from row values

Is it actually possible to rotate a T-SQL (2005) so that (for the sake of argument) the values of the first …

tsql pivot database-table
Mysql primary key when using INSERT INTO ... ON DUPLICATE KEY UPDATE

My table structure is: CREATE TABLE IF NOT EXISTS `users_settings_temp` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `userid` …

mysql primary-key insert-update database-table
database design: what fields are must for a user table in database?

I am trying to design a user table for MySQL. for now, my user table looks like this users ( BIGINT …

mysql database-table
Is there any reason to worry about the column order in a table?

I know you can ALTER the column order in MySQL with FIRST and AFTER, but why would you want to …

mysql sql database-table
Creating Multiple tables in SQLite on Android

Hi there i want to create two distinct tables in a database. These tables are User_details and Creditcard_details …

android sqlite database-table