create table "table-name" -> exclude the quotes when creating the table
after this a message will come : table created
(row_name data type(limit of characters),... )
for example
(name varchar2(20)).
This will make a column(attribute) in your table with the name "name" and data type varchar with character limit of 20.
you can further add more attributes in the same manner.
to insert values in the table you need this:
insert into "table name" values(123,qwew,wsd,2342)
the data in the brackets above depends on the attributes of your table.
and now you have created a simple table.
you can update, delete, alter, drop the table.
create table tb (id int primary key, name varchar(10) not null, age int) tb - name of the 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.
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
A SQL UPDATE statement allows the user to update existing records in a database table. For example, it could be used to update a customer's address, or a the price of a product.
Tables are defined with CREATE TABLE command. Syntax of CREATE TABLE command is: CREATE TABLE ( [] []);
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.
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
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.
temp table
If your using Ms SQL, use enterprise manager to export all scripts for a particular table in one file
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.
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; /
Some of the operations performed in DDL in sql are creation of table,alteration of table,truncate a table, drop a table
SQL (Structured Query Language) enables a database administrator to define schema components, such as tables, columns, indexes, and relationships in a database. By using SQL commands like CREATE TABLE, ALTER TABLE, and CREATE INDEX, administrators can create and modify the structure of a database according to their requirements.
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
SQL commands are specific structured query language keywords that are used to create, alter, and view data held withing a database. (Ex. SELECT, CREATE, ALTER) For more information about SQL: http://en.wikipedia.org/wiki/SQL