Snippet

Storing Variable-Length Text with VARCHAR

The VARCHAR data type stores dynamic string values up to a maximum character limit, optimizing disk storage when text lengths vary.

snippet.sql

sql

CREATE TABLE user_profiles (
  user_id INTEGER,
  username VARCHAR(50)
);

Breakdown

CREATE TABLE user_profiles (

Initiates the creation of a table named user_profiles.

user_id INTEGER,

Defines an integer column intended for user numeric IDs.

username VARCHAR(50)

Defines a variable-length string column storing up to 50 characters.

);

Closes the table definition statement.