The CREATE TABLE statement defines a table. The definition must include its name and the names and attributes of its columns. The definition may include other attributes of the table, such as its primary key or check constraints.
Other News
Data Obfuscation and Encryption
(Jared Still) Data encryption is a hot topic these days. This is hardly a new subject, but has received and increasing amount of attention, largely due to ecommerce. Protecting credit card numbers, medical data and other sensitive information has become more important than ever before, and on a lar
The Challenge of Performance Tuning–sample chapter
(Chris Lawson) Database Administrators, or DBAs, perform a wide variety of tasks – some exciting, and others more routine. At most companies, the DBA doesn’t have the option to pick and choose which tasks to perform. Typically, all the DBAs have to “pitch-in” and work on a wide variety of tasks, so
New Version Showcases Native XML Type and Advanced Data Handling
(Bob Beauchemin) The next version of Microsoft SQL Server, code-named “Yukon,” represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging ind
Why We Need XML Query Standards
(Jonathan Robie) Despite a shortage of sophisticated XML query tools, Internet demands have forced companies to present their data in various formats. In one sense little has changed, as SQL queries have long been used to combine data for different purposes and audiences. Now however, the output is
Reporting Bad SQL Code in DB2
(Marin Komadina) To find the slow-running SQL, we need to collect and analyze all SQL statements coming into the database, for a period of high system utilization. Previously presented “top” UNIX system commands can be used to identify a period for collecting SQL statements. After the system returns
DBCC Commands
(Michael Otey) Using Database Consistency Checker (DBCC) commands can give you valuable insight into what’s going on inside your SQL Server system. DBCC commands have powerful documented functions and many undocumented capabilities that you might not know about. You can learn more about undocumented
Check Your Form with Validator
(James Holmes) One major benefit of the Struts framework is its built-in interface for performing data validations on incoming form data. If any validations fail, the application redisplays the HTML form so that the invalid data can be corrected. Otherwise, processing continues. The Struts framework
WAP / WML Tutorial — Free
The WAP protocol is the leading standard for information services on wireless terminals like digital mobile phones. WML is the language used to create pages to be displayed in a WAP browser. In our WAP tutorial you will learn about WAP and WML, and how to convert your HTML pages to pocket format,
Considering SQLJ for Your DB2 V8 Java Applications
(Connie Tsui) There are two standard ways to access relational data using Java: SQLJ and JDBC. Why should you consider SQLJ for your IBM DB2 Universal Database™ (UDB) applications? The answer is that SQLJ is the language of choice for application programmers concerned with security, performance, and