Articles by "SQL"

Showing posts with label SQL. Show all posts

,
The CREATE TABLE statement is used to create a table in a database.

Syntax :
            CREATE TABLE table_name
            (
              column_name1 data_type,
              column_name2 data_type,
              column_name3 data_type,
             ....
            )

Ex :
            CREATE TABLE Student
            (
              IdStudent int,
              FirstName char (50),
              LastName char (50),
              Addreas varchar (200)
             )




TAG: SQL statement, database, table, student
Detail »

,
The CREATE INDEX statement is used to create indexes in tables.

Indexes allow the database application to find data fast; without reading the whole table.

SQL CREATE INDEX Syntax
Syntax :
            CREATE INDEX index_name  ON table_name (column_name)
Ex :
            CREATE INDEX IdStudent ON Student (LastName)


SQL CREATE UNIQUE INDEX Syntax
Syntax :
            CREATE UNIQUE INDEX index_name ON table_name (column_name)
Ex :
            CREATE INDEX IdStudent ON Student (LastName, FirstName)
TAG: SQL statement, database, table, student
Detail »
Subscribe to: Posts (Atom)

Author Name

Contact Form

Name

Email *

Message *

Powered by Blogger.