0
create table tb (id int primary key, name varchar(10) not null, age int)
tb - name of the table
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
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
How many Microsoft SQL server versions exist?
As at 2012, thirteen different versions of Microsoft SQL server had been issued. The version 1 was released in 1989 and the latest version is SQL Server 2012. Each version has multiple editions for use with different applications.
What is the difference between sql and Microsoft Excel?
SQL means Structured Query Language. It is a programming language which is mainly used for maintaining databases. Excel is one of the application developed by Microsoft to do calculations, graphs using spreadsheets.
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 the difference between T-sql and sql?
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
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
Where could one purchase a Sequel or SQL server?
The Sequel, or SQL, Server is owned by Microsoft. One can purchase an SQL Server from the Microsoft website. Microsoft also offers a free trial of the SQL Server.
What is the difference between Microsoft sql server architecture and oracle 8i database management system architecture?
in sql server you need to create separate databases for new project whereas in oracle only one database that is server for creating new project you need to create new tablespace like hr,inventory both r separate table spaces like different databases in sql server
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 should I get sql training for?
SQL training is needed if you are going to be working with Microsoft SQL Databases
Examples for dbms and rdbms?
My sql, Microsoft sql , Microsoft Access, dBase, Filemaker pro are the examples for dbms and oracle and sql server are the examples for rdbms
How does the Microsoft SQL Server compare with others?
According to a variety of sites that were researched, it has been found that the Microsoft SQL Server has very high ratings. There are many more features of Microsoft SQL than there are with others such as Oracle.
How can one explain what Microsoft SQL Hosting is?
The best place to get more information about Microsoft SQL Hosting is to go directly to Microsoft. There is so much information on SQL Hosting so one can get all the information they need.
What feature do you use to create a more complex table in Microsoft Word?
Draw Table Feature
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; /
