SQL Create table script from DBMS contains [ ] <p>If some one does right click on a given Table in a Database using SQL Server management Studio from Microsoft and create script table to query window, it displays the create table code in the window. I notice something like the following</p> <p>CREATE TABLE [dbo].[Login]( <br> [UserId] [int] NOT NULL,<br> [LoginName] nvarchar COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, <br> etc <br> )<br></p> <p>Is this how it appears in other DBMS too ? <br> Is this something specific to DBMS used ? <br> Is it just a fancy view only ?</p> <p>Why are "<b>[ ]</b>" used around column names and table names. Simple TSQL definition would look something like <br> CREATE TABLE table_name ( <br> Column#1 Datatype NOT NULL, <br> Column#2 Datatype NOT NULL UNIQUE, <br> -- etc... <br> ) <br></p> <p>Please dont mind my silly questions.</p> <p>Thanks in advance,<br> Balaji S</p>