For more information, see the SET command. This may give unexpected text wrapping in your display. Decreasing or increasing the linesize with the SET LINESIZE command usually makes each column proportionally smaller or larger. To control the width of the data displayed, use the SET LINESIZE command.Ĭolumns output for the DESCRIBE command are typically allocated a proportion of the linesize currently specified. You can also display the line number and indentation of the attribute or column name when an object contains multiple object types. The DESCRIBE command enables you to describe objects recursively to the depth level set in the SET DESCRIBE command. When you do a DESCRIBE, VARCHAR columns are returned with a type of VARCHAR2. Precision of columns (and scale, if any, for a numeric column) CREATE TABLE recipeingredients ( recipeid int NOT NULL, ingredientid INT NOT NULL, amount INT NOT NULL, PRIMARY KEY (recipeid,ingredientid) ). Whether or not null values are allowed (NULL or NOT NULL) for each columnĭatatype of columns, for example, CHAR, DATE, LONG, LONGRAW, NUMBER, RAW, ROWID, VARCHAR2 (VARCHAR), or XMLType The description for tables, views, types and synonyms contains the following information: For more information on which privileges allow access to another table in a different schema, refer to the Oracle Database SQL Reference. Represents the table, view, type, procedure, function, package or synonym you wish to db_linkĬonsists of the database link name corresponding to the database where object exists. From the Tables node, right-click it and select New > Table. If you omit schema, SQL*Plus assumes you own object. To create a table using the new-table wizard: From SMSS, within the Object Explorer, expand the tree for the relevant database. Represents the schema where the object resides.

Lists the column definitions for the specified table, view or synonym, or the specifications for the specified function or procedure.

Sql server create table