0
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.
What else can I help you with?
How do you create a table in Microsoft SQL?
create table tb (id int primary key, name varchar(10) not null, age int) tb - name of the table
Which command is used to new table in the RDBMS?
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.
How a primary key is fixed in a sql 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
What can a SQL UPDATE statement allow one to do within a table?
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.
What command is used to create a table?
Tables are defined with CREATE TABLE command. Syntax of CREATE TABLE command is: CREATE TABLE ( [] []);
What does SQL CREATE VIEW achieve?
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.
What is procedure to create a table in sql?
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
How do you create a table in Microsoft SQL?
create table tb (id int primary key, name varchar(10) not null, age int) tb - name of the table
Create view in SQL?
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.
What is hash table in sql?
temp table
How do you create a table using another table including constraints?
If your using Ms SQL, use enterprise manager to export all scripts for a particular table in one file
Which command is used to new table in the RDBMS?
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.
What is the syntax of oracle dynamic sql?
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; /
What is the name of two DDL operations in SQL?
Some of the operations performed in DDL in sql are creation of table,alteration of table,truncate a table, drop a table
What language Enables a database administrator to define schema components?
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.
How a primary key is fixed in a sql 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
What are sql commands?
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
