Variable-length storage with a maximum size of 1GB data Variable-length storage with provided max characters Variable-length storage with a maximum length of 4,000 characters SQL Unicode Character and String Data Types Datatypeįixed length with maximum length of 4,000 characters Note that all the above data types are for character stream, they should not be used with Unicode data. Variable-length storage with maximum size of 2GB data Variable-length storage with provided max characters, not supported in MySQL Variable-length storage with a maximum length of 8,000 characters SQL Character and String Data Types Datatypeįixed length with a maximum length of 8,000 characters Unicode character string data types, for example nchar, nvarchar, ntext, etc. Character and String data types such as char, varchar, text, etc. Date and Time data types such as Date, Time, Datetime, etc. Numeric data types such as int, tinyint, bigint, float, real, etc. Range 70 to 69, representing 1970 to 2069. SQL data types can be broadly divided into following categories. Stores year in 2 digits or 4 digit format. Stores number of seconds passed since the Unix epoch (‘ 00:00:00’ UTC) Stores date and time information in the format YYYY-MM-DD HH:MI:SS Let’s look into different categories of SQL data types in detail. Idea is to have the knowledge of what data type to be used in a specific scenario. Every relational database vendor has its own maximum size limit for different data types, you don’t need to remember the limit.For example, Microsoft SQL Server has money and smallmoney data types but since it’s not supported by other popular database vendors, it’s not listed here. Some relational database vendors have their own data types that might be not listed here. Data types listed here doesn’t include all the data types, these are the most popularly used data types.So while designing database schema and writing SQL queries, make sure to check if the data types are supported or not. For example, Oracle database doesn’t support DATETIME and MySQL doesn’t support CLOB data type. Not all data types are supported by every relational database vendor.
Miscellaneous data types – clob, blob, xml, cursor, table, etc.Binary data types such as binary, varbinary, etc.Unicode character string data types, for example nchar, nvarchar, ntext, etc.Character and String data types such as char, varchar, text, etc.Date and Time data types such as Date, Time, Datetime, etc.Numeric data types such as int, tinyint, bigint, float, real, etc.Restore database objects that have been dropped.Īccess numerous reports to help you better manage the database objects in your schema.įor those with DBA access, you can review the underlying database details.įor those with DBA access, you can run database activity reports. The Methods on Tables utility enables you to create an application programming interface (API), or package, for DML operations on specified tables. You can compare all objects in the schemas or limit your report to specific objects. You can run a report that compares database objects in two schemas, displaying differences between them. Specify layout properties to consistently generate items / columns across pages and applications. You can generate data definition language (DDL) statements for all or selected database objects within your schema. Use Sample datasets to build sample applications. Rapidly design and prototype data models using a markdown-like shorthand syntax that expands to standards-based Oracle SQL. You can also create relationships between objects, view formatted query results, and save queries with little or no SQL knowledge.
You can also unload data to text or XML.īuild queries graphically by adding tables and views into a panel, and selecting columns to return. You can load from text, XML, or a spreadsheet into a new table or an existing table. Data Workshop enables you to load and unload data to the database.