The maximum number of bytes per row is generally 8,060 bytes. PRIMARY KEY constraints default to CLUSTERED, and UNIQUE constraints default to NONCLUSTERED.ДЇOREIGN KEY REFERENCES - A constraint to provide referential integrity for the data, requires a UNIQUE INDEX on the referenced table. NOT FOR REPLICATION - Do not enforce constraints for the replication agent (IDENTITY, FOREIGN KEY and CHECK constraints.)Д¬ONSTRAINT - Define a PRIMARY KEY, NOT NULL, UNIQUE, FOREIGN KEY, or CHECK constraint.Д¬LUSTERED | NONCLUSTERED - The type of index is created for a PRIMARY KEY or UNIQUE constraint. NULL / NOT NULL - Whether the column can accept null values. IDENTITY - An identity column, one per table: tinyint, smallint, int, bigint, decimal(p,0), or numeric(p,0) TEXTIMAGE_ON - Specifies an alternate storage filegroup for columns of type: text, ntext, image, xml, varchar(max), nvarchar(max), varbinary(max), and CLR user-defined type.Д¬ONTENT - Allow multiple top-level elements in each instance of the xml data type.ДOCUMENT - Allow only one top-level element in each instance of the xml data type.ДEFAULT - A value provided for the column when nothing is explicitly supplied during an insert. ON 'default' (or if ON is not specified at all) - The table is stored on the default filegroup. ON - Table with partitions stored on one or more filegroups. A computed column is not physically stored in the table, unless the column is marked PERSISTED. The name 'timestamp' is used if no name is specified for a timestamp data type column.Д¬omputed_column_expression - An expression that defines the value of a computed column. If you want to see table columns then expand the table, you will see all the columns.( ]Д¬HECK ( logical_expression )Д¬olumn - A maximum of 128 characters. Next, expand the Database under you created a table, then expand the table folder under that you will see a table that you created. You can also check the table in Object Explorer, Go to SQL Server Object Explorer then click on Databases folder. You can see, it returns complete details of table interms of columns that table contains, column data types and size, table created date and other details. Lets execute the SP passing a table name as parameter. You can also see check the table structure such as all columns name of table their Data type, and size and other valuable information using a SQL Server inbuilt system stored procedure SP_HELP

ДЄs you can in below screenshot, It returns blank data which means employee table is created in database.

You can check whether a table is created or not, using Select Statement.

ДЄs you can see below screenshot, create table command executed successfully. If NOT NULL options is specified for column then value for the column should not be empty.ДЇollowing SQL Create Table statement creates a new table named as Emp_Info in database. NULL | NOT NULL It is an optional, If NULL option is specified then column will accept both normal values and NULL values. SQL CREATE TABLE statement is used to create a new table in a databaseД¬olumn_name1 Data_Type(Size) ,Д¬olumn_name2 Data_Type(Size) ,Д¬olumn_N Data_Type(Size) Д¬olumn_Name1, Column_Name2, Column_NameN is columns that you want for table.Дata Type(Size) is a validВ SQL Server Data Types with expected size of valuesВ that the column will hold.

Sql server create table