How to get the text of create table sql when I know the table name
-
How can I get the text of create table sql when I know the table name? Is there any view I can query for? for example I create a table T in oracle database. Can I get the text of its create table sql through oracle view? "create table T (sno number(3,0) primary key);" Many thanks.
-
How can I get the text of create table sql when I know the table name? Is there any view I can query for? for example I create a table T in oracle database. Can I get the text of its create table sql through oracle view? "create table T (sno number(3,0) primary key);" Many thanks.
Open query analyzer. Press F8 if the object browser is not present. Select your database and then right click on the appropriate table. Cursor over Script Object To New Window As then select Create. Regards Guy
You always pass failure on the way to success.
-
Open query analyzer. Press F8 if the object browser is not present. Select your database and then right click on the appropriate table. Cursor over Script Object To New Window As then select Create. Regards Guy
You always pass failure on the way to success.