We can create a table in sql using CREATE TABLE command.CREATE TABLE is having a complex syntax. Few examples on how to create a table are listed below
CREATE TABLE tablename
(
Fieldname1 datatype,
Fieldname2 datatype,
.
.
.
FieldnameN datatype
);
Example:
create table faculty
(
fname varchar(30),
addr varchar(30),
phone char(12),
email varchar(50),
doj datetime,
sal money,
expr varchar(20)
)
If you want to make a field as key field,you can do by specifying as primary key.
CREATE TABLE tablename
(
Fieldname1 datatype primary key,
Fieldname2 datatype,
);
Example:
create table skillset
(skid int primary key,
skname varchar(15)
)
For more help on datatypes check out
http://msdn.microsoft.com/en-us/library/ms187752(SQL.90).aspx
For more help on creating table in sql checkout
http://msdn.microsoft.com/en-us/library/ms174979(SQL.90).aspx
anandmca08@gmail.com
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.
create table tb (id int primary key, name varchar(10) not null, age int) tb - name of the table
create view vw_active_employee as select * from employee where status = 'Active' after creating the view, view can be used as a table to see active employee. e.g. select * from vw_active_employee Basically we save sql as a database object, so that we can use that in future as a virtual table.
In a relational database management system (RDBMS), the command for creating a new table is "CREATE TABLE". This is the standard in most SQL programs.
If your using Ms SQL, use enterprise manager to export all scripts for a particular table in one file
The syntax for dynamic sql is For example if you want to create table at run time then syntax is Declare V-string varchar2(900); begin V_string:='create table ORACLE (empno number,ename varchar2(90)'); execute immediate V_string; end; /
temp table
Some of the operations performed in DDL in sql are creation of table,alteration of table,truncate a table, drop a table
A primary key field in a sql table is created using the PRIMARY KEY keyword. ex: CREATE TABLE tbl_employee ( emp_num VARCHAR(10), emp_name VARCHAR(100), PRIMARY KEY (emp_num)) The above script creates a table called tbl_employee and sets the emp_num field as the primary key
The Data Definition Language (DDL). This component of the SQL language is used to create and modify tables and other objects in the database. For tables there are three main commands:CREATE TABLE tablename to create a table in the databaseDROP TABLE tablename to remove a table from the databaseALTER TABLE tablename to add or remove columns from a table in the database.The Data Manipulation Language (DML) component of the SQL language is used to manipulate data within a table. There are four main commands:then,SELECT to select rows of data from a tableINSERT to insert rows of data into a tableUPDATE to change rows of data in a tableDELETE to remove rows of data from a table
A SQL virtual table is called a "view". Views are virtual tables that contain the result set of a SELECT query and can be used to simplify complex queries or provide a layer of abstraction over the underlying tables.