DROP TABLE TABLENAME CASCADE CONSTRAINTS ;
CREATE TABLE TABLENAME (
COL1 NUMBER(3) NOT NULL,
COL2 VARCHAR2(2),
COL3 VARCHAR2(30) DEFAULT USER NOT NULL,
UPDATEDBY VARCHAR2(30) DEFAULT USER NOT NULL,
DTCREATED DATE DEFAULT SYSDATE NOT NULL,
DTUPDATED DATE DEFAULT SYSDATE NOT NULL,
STATUS NUMBER(3) DEFAULT 1 NOT NULL,
ACTV NUMBER(1) DEFAULT 1 NOT NULL,
DESCRIPTION VARCHAR2(50),
GRANT SELECT ON TABLENAME TO READONLY;
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 18, 2000 10:31 AM
To: [EMAIL PROTECTED]
Subject: SQL Create Table Statement
I am having major cranial flatulence today and can't remember how to write
a create table statement. I don't have access to SQL server's book's
online othewise I'd look up the syntax there. I'm also not the owner of
the database so I can't use the enterprise manager.
Any help would be appreciated.
TIA,
--Katrina
====================
Katrina Chapman
Consultant
Ameriquest Mortgage
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body...
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.