0

What is the code for “any unspecified field type is text” in sql?

I’ve tried using replace and I’ve searched multiple sites but I haven’t found a solution

Stephan
  • 5,891
  • 1
  • 16
  • 24
user18704585
  • 1
  • depends on RDBMS you use, e.g. in PostgreSQL there is datatype text – Sergey Apr 04 '22 at 16:50
  • i think datatype Text is specified in the standards – nbk Apr 04 '22 at 16:53
  • It’s PostgreSQL. Is there a specific code I should be writing? Right now when I try to create a table I get the error “Cannot read properties of undefined” – user18704585 Apr 04 '22 at 17:39
  • Please post your table (ddl) definition script. Also exactly what do you mean by *unspecified field type*. – Belayer Apr 05 '22 at 00:29
  • Requirements: Drop tables employee, contact, and address if they already exist Any unspecified field type is text. Create a table called employee with fields for id as int, fname, lname, age as int, hiredate as date. – user18704585 Apr 05 '22 at 13:32

0 Answers0