python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - ddl

how to get DDL (create query of a table) of a table from SQL Developer

am using Spool in SQL Developer to get the Output into a CSV file. where as i have heard of use of DDL command can b done to get the create query of a table. my query is as below spool "path/...
test-img

Salva

oracle

oracle-sqldeveloper

ddl

Votes: 0

Answers: 2

Latest Answer

How about set sqlformat loader spool "path/output.csv" select * from table; spool off; Based on comments you posted, it looks like you want to spool CREATE TABLE statement. If so, use DBM...
test-img

Littlefoot

PostgreSQL - Get DDL for materialized view

I need to be able to get the DDL from a materialized view. We are wanting to track how often a MV gets updated/changed, and I want to be able to automate this process. I just need the DDL for the MV...
test-img

Chris S

postgresql

ddl

Votes: 0

Answers: 1

Latest Answer

You can get the view definition like this: SELECT pg_get_viewdef('schemaname.mvname'); To get the complete DDL statement, prepend the following: CREATE MATERIALIZED VIEW schemaname.mvname AS The onl...
test-img

Laurenz Albe

how to create new table in mysql with date default value for current date?

I am trying the following code: create table People ( first_name varchar(15) not null, last_name varchar(15) not null, registration_date date not null); How can I make a default value for the ...
test-img

ILovePizza

mysql

sql

ddl

Votes: 0

Answers: 2

Latest Answer

You can use current_date create table People ( first_name varchar(15) not null, last_name varchar(15) not null, registration_date date not null DEFAULT (CURRENT_DATE) );
test-img

user8193706

Abort SQL before DDL operation being executed

My question if it's possible to avoid the execution of a DDL operation in an SQL script if the previous operation returns an Error. SQL script WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK; MERGE finalT...
test-img

Jorge Vega Sánchez

sql

oracle

ddl

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs