I am in school and as a project I am building a mock Database from SQL Statements. I like having clean code and since I am at home building these statements on notepad to execute at school later I have a questions about white space.

When I use CREATE TABLE <Table_Name> can I use tabs between column and data characters for clean space, or will SQL not execute properly unless it is a space?

I am used to programming where white space can be used to structure commands, I just want to know if this holds true in SQL.

Thank you,


SQL doesn't care about excessive whitespace.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.